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.
Morning,
I have my date table, a date column in my data table and I'm trying to have appear on my x-axis "Fri 21" instead of having the full date from the date column or having to use the date from my data column.
I've tried FORMAT but I'm unable to get it to properly sort. I'm unable to change the format and type under modelling or edit in query editor to achieve the format I'd like.
Thoughts?
Solved! Go to Solution.
The best way I've found to do it is;
DayDate = FORMAT('ExtendedCalendar'[DateKey].[Date], "ddd d")
To format my date the way I'd like. Then Sort the Column by "Day of Month".
You can try using the methods shown here uisng FORMAT function:
https://msdn.microsoft.com/en-us/library/ee634398.aspx
or
Create a day column in your table using the FORMAT function and Combine the Day Part and Date Integer to get the desired results.
Thanks for the response. I've done that; but when you try to use that on a graph it doesn't show the dates in the correct order (for eg; Thurs the 20th is after Friday the 21st) like in my picture.
You can't convert the FORMAT'd column into a date as it errors out. Thoughts?
The best way I've found to do it is;
DayDate = FORMAT('ExtendedCalendar'[DateKey].[Date], "ddd d")
To format my date the way I'd like. Then Sort the Column by "Day of Month".
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |