PowerView month issue

Question

Hi,

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.

regards

Answer 1

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.

HTH,
Robert

---

Robert Bruckner   http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.