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.

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

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.