Forum Discussion

kevinslaughter's avatar
kevinslaughter
Regular Visitor
1 year ago
Solved

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

  • 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.