22 Maret 2012 14:47
i want to represent my data per month in powerview, but the month is showing in an onlogical way "alfabetic" instead of starting with
January February ... it starts with april august ...
how can you fix this? in my database i have a column with only dates
so i insert my database in a tabular project and dit a data analysis expression on the data
=format(datavalue(mydate);"mmmm") so this gave me the right month name
i also tried to insert a table month with the months in the right order but in powerview they automaticly sort alfabetic
how can i solve this.
- Diedit oleh matthias1989 22 Maret 2012 15:08
23 Maret 2012 16:03Pemilik
Open the model in PowerPivot, make sure the table with the month name column also contain a separate column with month number, and then in the PowerPivot ribbon, Home tab, select Sort by Column. In the Sort by Column dialog, specify that the MonthName column should be sorted by MonthNumber.
Save the model, and create a Power View report from it - it will sort MonthNames based on the month number.
Robert Bruckner http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.
- Ditandai sebagai Jawaban oleh matthias1989 26 Maret 2012 8:09