Forum Discussion
Need to Create dynamic matrix view based on slicer value
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?
2 Replies
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-fc4095ae9afd
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdfHi 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
