Forum Discussion

Sowmiya's avatar
Sowmiya
Helper III
7 years ago
Solved

DAX

Hi Community,
Help me with DAX.
Date is added as Slicer. Amount is displayed Monthwise. When date is Filtered between 12-1-2018 to 3-1-2019,
I want the Visual to Show Month in the order of December, Jan and Feb.

Thanks in Advance,
Ambhika

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Sowmiya 

    Add date hierarchy in the "Date" field of the line chart,

    remove "quarter" and "day", keep the "year" and "month".

    Then "expand all down one level"

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • Nishantjain's avatar
    Nishantjain
    Continued Contributor
    7 years ago

    Sowmiya 

     

    You question isn't clear. Can you post any screenshot?

     

    How is it displaying right now?

    • Sowmiya's avatar
      Sowmiya
      Helper III
      7 years ago

      Hi,
      I have Date Slicer filtered between 12/11/2016 to 5/20/2017.
      Date SlicerNow, The Visuals Shows Month in the Order as Jan, Feb, March, April, May and Dec
      But, I want Visual to display Month in the Order Dec, Jan, Feb, March, April and May

      • Nishantjain's avatar
        Nishantjain
        Continued Contributor
        7 years ago
        Have you tried to bring in both month and year? E.g. bring jan-17 instead of just Jan.
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Sowmiya,

     

    Basically, you need to sort out the month column in your date dimension.

     

    For this, you need to have one more calculated column in your date dimension and it should be formatted to MMYYYY

     

    And the same column has to be used in the month column and saying that sort by MMYYYY

     

    Once these two steps has been completed, you can see the charts that you will have months in order.

     

    Regards,

    Pradeep