DAX

[Sowmiya]

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

[Anonymous]

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

[Nishantjain]

@Sowmiya 

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

How is it displaying right now?

[Sowmiya]

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 · Accepted solution]

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]

Have you tried to bring in both month and year? E.g. bring jan-17 instead of just Jan.