Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
93 | |
88 | |
70 |
User | Count |
---|---|
166 | |
133 | |
129 | |
102 | |
98 |