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.
I have a date column in my table:
Date |
1/1/2022 |
2/1/2022 |
3/1/2022 |
4/1/2022 |
I want to display the date in a matrix visual as "MMM-YY". I don't see that format as a choice in the format display options. If I use FORMAT(Date,"MMM/YY"), I lose the sorting by date as the column becomes text.
It seems like this is an easy problem to solve. Is there any way to add a custom format type to the date Format drop down?
Thanks.
Solved! Go to Solution.
you can transform the data in Power Query when you load the data into POwer BI.
Date.FromText([Date],[Format="M/d/yyyy"])
Please make sure to write months in capital M and the restr in small letters.
Date.FromText - PowerQuery M | Microsoft Learn
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Awesome! I never knew you could do that. Thank you!
you can transform the data in Power Query when you load the data into POwer BI.
Date.FromText([Date],[Format="M/d/yyyy"])
Please make sure to write months in capital M and the restr in small letters.
Date.FromText - PowerQuery M | Microsoft Learn
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
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 |