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