Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
Hi,
I have Date Slicer filtered between 12/11/2016 to 5/20/2017.
But, I want Visual to display Month in the Order Dec, Jan, Feb, March, April and May
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |