Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |