Forum Discussion
Possible to create multiple hierarchies
As an example, I have 2 hierarchies that I would like to add into Matrix viz so we can flex our analysis using one or both together
1. Period
Year Qtr Month
2024 Q4 Oct
2024 Q4 Nov
2. Account category
Level1 Level2
Margin Sales
Margin Cost
Unfortunately I can only create one hierarchy that I need to drill all the way through.
Is it possible to have 2 (or more) seperate hierarchies in Power BI matrix columns? We would like to drill something like ...
Q4
Margin
$100
and then drill into Q4 ..
Q4
Oct Nov Total
Margin Margin Margin
$60 $40 $100
and then drill into Margin
Q4
Oct Oct Oct Nov Nov Nov
Sales Cost Margin Sales Cost Margin
$100 -$40 $60 $110 -$70 $40
and then collapse Qtr and see ...
Q4
Sales Cost Margin
$210 -$110 $100
Many thanks
Kevin
Enable "Personalize Visuals" and teach your users how to use that. Alternatively, use field parameters. Both options allow report users to decide on the order of items in the visual.
1 Reply
- lbendlin
Super User
Enable "Personalize Visuals" and teach your users how to use that. Alternatively, use field parameters. Both options allow report users to decide on the order of items in the visual.