Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
How can I create hierarchical headers in matrix?
For example, I've got the current view:
2020 | 2021 | |||
Channel | Spots per block AVG | Spots per block MAX | Spots per block AVG | Spots per block MAX |
ABC | 123 | 123 | 123 | 123 |
I'd like to change view to:
Spots per block | ||||
AVG | MAX | |||
Channel | 2020 | 2021 | 2020 | 2021 |
ABC | 123 | 123 | 123 | 123 |
Where [Spots per block AVG] & [Spots per block MAX] it's measures.
I know, that I could move measures to rows, but I need exact hierarchical in columns headers.
Solved! Go to Solution.
@Denis_Slav Maybe: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community
Does the header structure have to be dynamic? if , so, under which cirteria?
Proud to be a Super User!
Paul on Linkedin.
No, in this case it should be fixed. But if it possible to create dynamical, it may be usefull for future.
@Denis_Slav Maybe: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community
Thanks. Yes, it looks what I need! Go to analyze, how to adopt it for my task. )
User | Count |
---|---|
136 | |
73 | |
72 | |
55 | |
55 |
User | Count |
---|---|
199 | |
95 | |
63 | |
62 | |
51 |