topic Re: How to set a default sorting for a chart? in DAX Commands and Tips

How to set a default sorting for a chart?

ironboy0418 — Sun, 02 Apr 2023 04:56:31 GMT

I do have two slicers that are inter-dependent with each other:

The objective is whichever I select weekly, monthly, or quarterly in the relative slicer. The below report will be sort not by its values rather by its relative date like the example below. The concern with this is that I always manually sort it everytime I select another view:

Is there a way we can sort it automatically using dax? or any other method?

Thanks in advance.

Re: How to set a default sorting for a chart?

MohammadLoran25 — Sun, 02 Apr 2023 09:21:21 GMT

Hi ironboy0418 ,

Click on your field (Year-month which you have put on you X-Axis)

Then from the upper ribbon in the "Column Tools" select the "Sort By Column" section and sort it by the column YearMonth (if you do not have YearMonth Field you can Create it as a calculated column in your datetable as below):

CONVERT(FORMAT(DateTable[Date],"YYYYMM"),INTEGER)

If this answer solves your problem, give it a thumbs up and accept it as a solution so the others would find what they need easier.

Regards,

Loran

Re: How to set a default sorting for a chart?

ironboy0418 — Sun, 02 Apr 2023 23:11:02 GMT

Thanks MohammadLoran25 It doesn't work this way please see below for reference:

Re: How to set a default sorting for a chart?

MohammadLoran25 — Mon, 03 Apr 2023 15:22:53 GMT

I could not get what you meant by the picture. Could you please wxplain more what is wrong with it exactly?

ironboy0418 Thanks.

Re: How to set a default sorting for a chart?

ironboy0418 — Mon, 03 Apr 2023 23:46:56 GMT

MohammadLoran25 It didn't achieve the objectives even if I did the above recommendation of yours