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've been looking for this for a while so thought I'd ask.
I use a matrix with ah Date hierarchy field to drill down in to lower levels (Year/Quarter/Month).
However, when I drill down you don't see what previous level you were on
e.g. if you drill down in to 2018 - Q1 - January you only see that you are in January and need to know what year you went in to.
Is there a quick way/option I'm missing to turn on to show the full "path" on the label/row? (without building a custom hierarchy where you add calculated columns and build it yourself)
Thanks!
Solved! Go to Solution.
@DirkRonsmans,
Please use the highlighted button to drill down your Matrix visual.
Regards,
Lydia
@DirkRonsmans,
Please use the highlighted button to drill down your Matrix visual.
Regards,
Lydia
@v-yuezhe-msft Can't believe I missed that one. I use it all the time when using multiple fields so they are stepped but it didn't occur to me that it would do the same for a Date hierarchy!
Thanks!
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |