Need to Create dynamic matrix view based on slicer value

[Rosy123]

Hello

I am struggling with creating dynamic view which needs to have below view when i select specific value in slicer as kdp , but different matrix view which has no sitetype row when other slicer values are selected .I tried using bookmarks however couldnt achieve this setup. As we have limitation of measure which cannot be used on row in matrix, m trying to find a workaround also location and site resiliency both are measures . the actual view i need to have is similar to what u see in below excel , which has location number as row not column, but i couldnt think of any way to replicate same view in powerbi so settled with 2nd view

Could someone help me please?

[Rosy123]

Hi @amitchandak ,

Thanks for looking into this and responding 

I dont think so field parameters can help me in this case. I did have a look at that option which helps in switching measures based on parameters selected.

What i want to achieve is bit different.

I need the row to disappear from matrix based on slicer value selection which is client field containing companies 

basically if i select slicer value as particular client i need to have below view ,if any value other than that is selected i need the site type row to disappear from matrix

[amitchandak]

@Rosy123 , check if Field Parameters can help

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf