Forum Discussion

Eddlugonz's avatar
Eddlugonz
New Member
6 years ago
Solved

Conditional Formatting - Two Variables or more

Greetings to all, I hope you will be all right! I would currently like to know if it is possible to conditionally format two or more values in a single array. My example case is as follows: I have ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Eddlugonz 

    Hope you mean in a sinle array is a single column.

    Create a measure as

    sold_stat = SWITCH(true(),

                       [col1] = "Sold",1,

                       [col1] = "Sold out",1,

                       [col1] = "Not Sold",1,0)

    You change chage your conditions as per your requirement. this is what I could make out of it.

    Then in the table or matrix go to formatting and Conditional formatting.

    Select sold_stat and apply the format.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Eddlugonz , Usually for the complex case I prefer the "Field value" Option in conditional formatting and use a measure with that.

With the current description, I am not able to suggest a measure. But refer to these examples.

 

Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

Color  = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

 

You can use meausres and dimesnions values with max/min/firstnonblank/lastnonblank etc.

 

Refer how to use here

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

 

In case you think this what can help you, see how the row context play a role in conditional formatting: https://youtu.be/Q1vPWmfI25o?t=2770