Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

How can I sort the text values in a filter object?

???
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Anonymous,

     

       as meysun said you have to use "Sort By Column".

     

    1) You have to create two calculated columns ("monthName" and "monthNumber") and visualize monthName as a filter.

     

     

    2) After that you have to select "Sort By Column" and sort by monthNumber, and you gain the result.

     

    Let Me Know If It Works.

     

    #I'M Not An Expert#

Tcook's avatar
Tcook
Advocate II
9 years ago

The solution is far easier than I thought. 

 

Steps

  1. In the "Fields" pane, click on the field that is being dispalyed.
  2. On the "Modeling" tab, click "Sort By Column".
  3. Chose the column that you want to sort the displayed field by.
  4. Viola
  • rmettu_1242's avatar
    rmettu_1242
    Advocate II
    9 years ago

    Thank you ,

    I have quick question. sorting is working fine in Power BI Desktop version. when i publish to power BI services, it's not shown sorting order 

    Any idea?