Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi there,
I created a graph showing the data in current month and upcoming 3 month, i.e. Apr to Jul, including months even has no data (e.g. Jun). I would like to change the month number into month name by using the date table. However, the month name cannot show the missing month data (e.g. Jun) and in wrong order (prefer ascending).
Appreciate for any help!
After change to "Month name", June data missed, not in acsending order, and I worry in the graph still be correct from 2024 Dec to 2025 Mar (whether be able to show the correct order in the x-axis).
My date table seems correct btw:
Solved! Go to Solution.
Whenever you want to sort your month name in proper order ( jan, feb...) then always sort it by month number.
DAX TO CREATE BOTH COLUMN ARE :
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Whenever you want to sort your month name in proper order ( jan, feb...) then always sort it by month number.
DAX TO CREATE BOTH COLUMN ARE :
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
First, you need to sort your column [Month Name] on column [Month] to make sure it's sorted (Jan, Feb, Mar, ... ) instead of (Apr, Aug Dec, ... )
Then you need to sort your chart by [Month Name]
to show empty months in the graph, select "Show items with no data" on column [Month name]
Thanks. I did sort by monthyear, but still cannot sort the month name in the graph..
Hi @rachelbi ,
the way it looks, "sort by column" has not yet fully worked.
You need a [month number] column in your date table which only includes the month number (1 for January, 2 for February ...).
Then you need to sort the [month name] column by [month number]
This video explains the issue and its solution step by step:
https://www.youtube.com/watch?v=NlX7Cp2P0d4
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |