Visualization which is green if yes or red if no

[andrea100]

Hi, I'm looking to create some kind of visualization like below. I have 3 different measures (D1,D2,D3). The 3 rectangles would represent the 3 difference measures.

If in any case D1 is yes then it is green, if it is no then it is red. 

If in any case D2 is yes then it is green, if it is no then it is red. 

If in any case D3 is yes then it is green, if it is no then it is red.  

Is there any way to do this in Power BI? I would appreciate any help and guidance. Thank you.

[djurecicK2 · Accepted solution]

Hi @andrea100 ,

 You can definitely do this- it is called conditional formatting. Here is additional information:

https://www.youtube.com/watch?v=m0h3Ghl6mgY

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color...

https://blog.coupler.io/power-bi-conditional-formatting/

[v-bofeng-msft · Accepted solution]

Hi @andrea100 ,

Thank you, @djurecicK2 , for sharing the solution. As @djurecicK2  rightly pointed out, if the visual you are using is a table, you can apply conditional formatting to dynamically set the fill color of each cell.

If the visual in question is simply an inserted rectangle shape, you may consider using a formula to set its fill color.

If these solutions do not meet your requirements, please consider providing additional information, such as the type of visual you are using, the DAX formulas for D1, D2, D3.

Best Regards,

Bof

[andrea100]

Thank you, going to use this for another report! 

[djurecicK2 · Accepted solution]

Hi @andrea100 ,

 You can definitely do this- it is called conditional formatting. Here is additional information:

https://www.youtube.com/watch?v=m0h3Ghl6mgY

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color...

https://blog.coupler.io/power-bi-conditional-formatting/

[andrea100]

Thank you, these resources definetly helped