Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
When I use a matrix and make the columns be some period of time (either month, or week, etc..), the column headers show numbers instead of the month name (Jan=1, Feb=2. etc) or week-ending date (shows week #'s 1 thru 52). How can I show the month name or week ending date instead? I used a standard dates table.
Thanks,
Steven
Hi @sshweky,
I used a standard dates table.
In your dates table, create two calculated columns.
MonthName = 'Dates table'[Date].[Month]
MonthNo = 'Dates table'[Date].[MonthNo]
Then, choose [MonthName] column, change its default sort by column to [MonthNo]. Set its order to Ascending.
Result.
Best regards,
Yuliana Gu
Hi,
For showing month names, drag that specific column to the Column labels section. You can extract the Month name from a date by using this formula
=FORMAT(Calendar[Date],"mmmm")
Hope this helps.
Thank you! But where is the columns label section?
In the visualisation pane, drop the Month name field from the Calendar table in the column section.
Thank you! OK that worked, but now my months show all out of order? How do I get them in the right order?
You are welcone. If my previous reply helped, please mark it as Answer. Try this
Now see your visual.
I'm so sorry to bother you! Where in the calnedar table do I type ' = RELATED(Month_Order[Order])'?
Hi,
Share the link from where i can download your file.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |