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
I am using a matrix table to display a view with headers based on date hierachy. I want to show the Month as Jan Feb etc not January February etc. I know how to change formats in PowerQuery and Dax but this does not reflect in the display formatting in the table headers? Can it be done?
Solved! Go to Solution.
Yeah, we don't do that around here. Auto Date time is a nightmare masquerading as a convenience. Switch to a proper Dates table structure.
Is this a date hierarchy from a single [Date] field or from separate year and month columns?
Format([Date],"mmm") is the default approach.
It is date hierarchy from a single [Date] field
Yeah, we don't do that around here. Auto Date time is a nightmare masquerading as a convenience. Switch to a proper Dates table structure.
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 |
---|---|
65 | |
61 | |
21 | |
18 | |
12 |