Forum Discussion
Fields parameters - Color your data
Irwin , You can know what is selected like
What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])
Based on this you can create a measure that return color based on measure used
simple example
color Measure =
Switch(True() ,
max(Table[ID]) in {10,20,30} ,"Red",
max(Table[ID]) in {5,15,25} ,"Blue",
"White"
)
Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)
You can use the same in conditional formatting using field value option
This seems like what i want. Could you elaborate more on the last two measures. I cannot get them to work and I am also unsure where I should place them?
"What is selected" - In the slicer ?
"Color measure" and "measure" - in the field value? How do they work? 🙂