Fields parameters - Color your data

[Irwin]

Hi guys,

I have several graphs (scatter plots) that I would like to combine to one by using the fields parameter. No problem. Done.

But when I want to apply the previous color coding I run into problems. How do I do this for multiple values sharing the y-axis?

My setup is date on x-axis, different values on y-axis (temperature/fat/protein/etc). If the value is below/above a certain limit it is green, if it is outside this then red.

Green/red is different from parameter to parameter.

Thank you for all help 🙂

[amitchandak]

@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

[Irwin]

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? 🙂