locked
PowerView month issue RRS feed

  • 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



    Thursday, March 22, 2012 2:47 PM

Answers

  • 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.

    • Marked as answer by matthias1989 Monday, March 26, 2012 8:09 AM
    Friday, March 23, 2012 4:03 PM