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