Forum Discussion

ironboy0418's avatar
ironboy0418
Icon for Helper II rankHelper II
3 years ago

How to set a default sorting for a chart?

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 s...
MohammadLoran25's avatar
MohammadLoran25
Icon for Solution Sage rankSolution Sage
3 years ago

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's avatar
    ironboy0418
    Icon for Helper II rankHelper II
    3 years ago

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

     

     

    • MohammadLoran25's avatar
      MohammadLoran25
      Icon for Solution Sage rankSolution Sage
      3 years ago

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

      ironboy0418  Thanks.

      • ironboy0418's avatar
        ironboy0418
        Icon for Helper II rankHelper II
        3 years ago

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