How to dynamically change the row fields in power bi matrix based on filter selection?

[Anonymous]

How to dynamically change the row fields level's in a power bi matrix.

For example, if I have a pivot table I can drag and put TZ and then Area or Area and TZ.

How do i get a similar functionality in PBI where I have a slicer that says fist level and I choose TZ and Second level where I choose Area etc... 

I tried this for one level. I tried dynamic columns using SELEVTEDVALUE and SWITCH but the same did not work for columns:

This worked:

Quant Slicer Selection =

IF (

ISCROSSFILTERED ( 'Quant'[Measure]),

SWITCH (

SELECTEDVALUE ( 'Quant'[Measure]),

"Billable Hours", sum('Raw Data'[Billable Hours]),

"HC", sum('Raw Data'[Headcount]),

"Workable Hours", sum('Raw Data'[Total Workable Hours])

),

" "

)

This did not work:

Column Slicer Selection =

IF (

ISCROSSFILTERED ( 'Level 1'[Field]),

SWITCH (

SELECTEDVALUE ( 'Level 1'[Field]),

"Area", [Area],

"Domain", [Domain],

"Function", [Function]

),

" "

)

[Anonymous]

Thank you so much, this worked!!

[jdbuchanan71 · Accepted solution]

If you enable user personalization of visuals then the users can change the fields on the rows rather than you having to make each possible combination.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals

You could give them the most common 3 using bookmark buttons then they could change it if they needed something else and save a personal bookmark.

[Anonymous]

Thank you!

I tried that however I would need to make a lot of options as I have many layers and combinations that I want to choose from.

I was wondering if there was another way to do this.

[jdbuchanan71]

You would need to use bookmarks to manipulate the fields that are on the rows or the order they appear in.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive