Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Power BI Enthusiasts,
I'm in need of some assistance with customizing the display format for a date hierarchy in Power BI. I’ve built a custom date table and established a hierarchy within it. It functions well, but I've encountered a cosmetic issue that I hope to resolve.
In the auto-datetime feature of Power BI, when drilling down to the lowest level, the dates are displayed in an abbreviated, compact format that’s very easy on the eyes.
However, with my custom hierarchy, the dates don’t retain this clean look when drilled down.
I tried concatenating labels to streamline the view, but the result was not satisfactory. The lowest level of drill-down becomes a long string of dates.
Does anyone have experience with formatting custom date hierarchies in Power BI to look as neat as the built-in auto-datetime feature, especially when drilling down to the day level? I'm looking for a way to keep the date parts (year, month, day) visually separated and yet as tidy as the default formatting (see first screenshot).
Your insights on how to approach this would be immensely valuable.
Thank you in advance for your time and help!
Warm regards,
Christian
Solved! Go to Solution.
For everyone who's interested, I found a (kind of) solution in those two articles:
https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/
https://www.sqlbi.com/articles/improving-temporal-line-charts-in-power-bi-with-dax/
For everyone who's interested, I found a (kind of) solution in those two articles:
https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/
https://www.sqlbi.com/articles/improving-temporal-line-charts-in-power-bi-with-dax/
@wookietreiber , Try concatenate label off and check if makes any difference
Concatenate Label off : https://youtu.be/QgI0vIGIOOk
Thanks for your reply! Unfortunatly that's what I am coming from (see second screenshot). So that does not do trick
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |