Forum Discussion

Hari_Gopal's avatar
Hari_Gopal
Advocate I
4 years ago

Month Slicer Sorting

Hello Everyone,   When I placed month names in a slicer which was sorted according to Indian fiscal year month number, I got the 2nd visual. But I want to display as 1st visual. Any sug...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Hari_Gopal 

In my pbix file , you can find the ID for slicer and number for column chart are different columns , in column chart , the sorting is based on the column of Apr=1, May=2 as the standard .

I changed it in my pbix file and attached it again , you can refer to it .

 

Best Regard

Community Support Team _ Ailsa Tao

  • Hari_Gopal's avatar
    Hari_Gopal
    Advocate I
    4 years ago

    Hi, I did understand what you did.

    The previous scenario what I mentioned has the following issues

     

    a) If we select present fiscal year, months order is changing in slicer and

    b) you placed number column in value field of bar chart but if we place some other value column in value field, how can we sort?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Hari_Gopal 

      Then you can only start with the name of the X-axis value, and you can add an order in front, but the display is not so good. Create a calculated column and put it in Axis .

      Column = 'Table'[number] & "-" &'Table'[Month]

      Best Regard

      Community Support Team _ Ailsa Tao

      • Hari_Gopal's avatar
        Hari_Gopal
        Advocate I
        4 years ago

        Ok, thank you Anonymous.

         

        But what about this thing

        a) Let us assume that we have fiscal year and respective months column,

         


              Present fiscal year doesnt have all the 12 months,  then months order in the slicer is changing. How can we fix it?