Forum Discussion

Irwin's avatar
Irwin
Helper IV
4 years ago

Fields parameters - Color your data

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 🙂

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Irwin
      Helper IV
      4 years ago

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