topic Re: Month Slicer Sorting in DAX Commands and Tips

Month Slicer Sorting

Hari_Gopal — Thu, 23 Dec 2021 13:25:24 GMT

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?

Re: Month Slicer Sorting

Greg_Deckler — Thu, 23 Dec 2021 13:27:15 GMT

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.

Re: Month Slicer Sorting

Hari_Gopal — Thu, 23 Dec 2021 13:30:15 GMT

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

Re: Month Slicer Sorting

Greg_Deckler — Thu, 23 Dec 2021 13:39:30 GMT

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.

Re: Month Slicer Sorting

Anonymous — Mon, 27 Dec 2021 05:16:59 GMT

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

Re: Month Slicer Sorting

Hari_Gopal — Mon, 27 Dec 2021 09:48:40 GMT

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)

Re: Month Slicer Sorting

Anonymous — Tue, 28 Dec 2021 01:43:34 GMT

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

Re: Month Slicer Sorting

Hari_Gopal — Tue, 28 Dec 2021 05:31:25 GMT

Hi, once look at the below scenario

Re: Month Slicer Sorting

Anonymous — Tue, 28 Dec 2021 05:50:50 GMT

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

Re: Month Slicer Sorting

Hari_Gopal — Tue, 28 Dec 2021 06:14:06 GMT

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?

Re: Month Slicer Sorting

Anonymous — Tue, 28 Dec 2021 06:46:07 GMT

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

Re: Month Slicer Sorting

Hari_Gopal — Wed, 29 Dec 2021 05:13:09 GMT

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?