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 Decembe...
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.

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.
    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      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.