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.
Hi,
I have a large matrix visual with several columns of dates. However, I quickly run out of horizontal real estate, and would like to condense the date columns down from a "Monday, July 15, 2019" format down to a "7/15/19", which takes up half of the space to show in the matrix. How can I achieve this?
Solved! Go to Solution.
You have to select the column in the table on the right then format it.
If you select your date column in the table list on the right you can set the formatting under the modeling tab.
@jdbuchanan71 thank you for your speedy reply!
When I select the column in my table, it resorts it, but the Formatting tab under Modeling remains greyed out. Am I selecting the column the right way, by clicking on the header?
I have double-checked to make sure that the column was formatted as "Date" in Querty Editor.
You have to select the column in the table on the right then format it.
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |