Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditionally formatting chart

Hello,   I want to format my chart in two colours, red and green.  In one column there are three options to select. For the options cXML and Online is a positive bar in green needed, and red if th...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Create a measure like (changes column and measure name as per need)

    Switch( True(),

    selectedvalues(Table[Method]) = "cXML" && [Measure] >=0, "Green",

    selectedvalues(Table[Method]) = "cXML" && [Measure] <0, "Red",

    selectedvalues(Table[Method]) = "paperinvoice " && [Measure] >=0, "Red",

    selectedvalues(Table[Method]) = "paperinvoice " && [Measure] <=0, "green",

    //add other condition

    "white"

    )

     

    Use this data color/conditional formatting using field value option

    How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Create a measure like (changes column and measure name as per need)

Switch( True(),

selectedvalues(Table[Method]) = "cXML" && [Measure] >=0, "Green",

selectedvalues(Table[Method]) = "cXML" && [Measure] <0, "Red",

selectedvalues(Table[Method]) = "paperinvoice " && [Measure] >=0, "Red",

selectedvalues(Table[Method]) = "paperinvoice " && [Measure] <=0, "green",

//add other condition

"white"

)

 

Use this data color/conditional formatting using field value option

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4