Forum Discussion
conditional background formatting to table based on slicer selection
Hi Folks, Here is the problem.. I want to get below result as of below screenshot using below data model and slicer and table Please note that , Slicer and table is used with...
Rasitha_PB , to do this you need slicer using an independent slicer table.
Then you can have measure like
color =
Switch( True () ,
max(Table[store]) in values(Store[Store]) , "Blue",
"White"
)
Then you can use conditional formatting with the field value option and use this measure
if needed , check
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Hi amitchandak ,
I am trying to find a different way , as I have many visuals in a Dashboard page as some of them are connected to this slicer.
