Month Slicer Sorting

[Hari_Gopal]

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

[Anonymous]

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]

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]

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]

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?

[Anonymous]

Hi @Hari_Gopal 

You can change the order in visual options, sort axis by fiscal month number and set Sort ascending . This operation does not affect the sequence of the slicer, because it is set in a single visual. You can have a try .

Best Regard

Community Support Team _ Ailsa Tao

[Hari_Gopal]

Hi, once look at the below scenario

[Anonymous]

Hi @Hari_Gopal 

In slicer , there are two orientations for Slicer : Vertical and Horizontal .When you choose Horizontal , the visual displays as the screenshot below .

So if you want to change the location of the Month , you need add a column to define the order of the Month . Then sort the month by the ID in Data view .

You will get a visual like this :

I have attached my pbix file , you can refer to it .

Best Regard

Community Support Team _ Ailsa Tao

[Hari_Gopal]

I also tried this way but the problem with this way is when we place this month column in bar chart, the order is different from the actual(apr, may, june ----mar)

[Greg_Deckler]

@Hari_Gopal Oh, I see it is sorting vertically versus horizontally. There is no setting that I know of to change that. However, if you shrink it vertically it will sort horizontally across.

[Greg_Deckler]

@Hari_Gopal So you generally need a column with the order you want and you use that as the "Sort by" column. Without seeing your data, it is hard to be more specific.

[Hari_Gopal]

It's a general month name column and sorted by fiscal month number( Apr = 1 to Mar = 12) column.