Forum Discussion

Eddlugonz's avatar
Eddlugonz
New Member
5 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 a product in different stores and I know which ones it has been sold in(1), it is sold out(2) and it is not sold(3).

Understanding that the product can be sold and sold out in a set time, when establishing the matrix by store and product, can I reflect the two possibilities of the product of the same store under a conditional format?

I hope the example is clear and you can support me.

Greetings and thanks!

  • Anonymous's avatar
    Anonymous
    5 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.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 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
    Super User
    5 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