How to set a default sorting for a chart?

[ironboy0418]

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.

[MohammadLoran25]

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

[ironboy0418]

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

[MohammadLoran25]

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

@ironboy0418  Thanks.

[ironboy0418]

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