Forum Discussion

datahue's avatar
datahue
New Member
4 years ago

Power BI Matrix Dynamic Row Headers

Hi All,

 

We have a requirement where we want to change the Row headers of a matrix visual based on Slicer selection.

 

For Example- Consider a table below.

 

Category, Region, Sales

A              East       100

B              East        200

C              West      400

D              West       500

 

We want to give a slicer where the two options are Category,Region.

If the User selects Category then the matrix visual shows 

 

Category     Sales

A                 100

B                  200

C                  400

D                  500

 

If The User selects Region then

 

Region       Sales

East            300

West           900

 

Also is there any possibility then this slicer can be multiselect? For Example show both Category and Region?

 

Thanks

Sumit

3 Replies