Is there a visual can show negative value as an icon in table?

[spagad6263]

Hi, I would like to show the variance % column as an icon, maybe Red light when Variance %<0, and Green light when Variance % >=0. Andy suggestion?

[ryan_mayu · Accepted solution]

@spagad6263 

you can try to use conditional formatting in table visual

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting?wt.mc...

[Ritaf1983 · Accepted solution]

Hi @spagad6263 
You can achieve the desired result with conditional formatting.
In the first step create the measure with the wanted logic.
For example :

Variance = DIVIDE(sum('Table'[Budget]),SUM('Table'[Actual]))-1

Then put the measures in the table and on variance apply the conditional formatting :

*The unreal big numbers are just because we need to five to the engine a range

Result:

Please note that from the perspective of effective data visualization, it is preferable to highlight only the negative (red) in the alert.

Green adds unnecessary noise, requires more decoding, and more.

The goal of the alert is always to draw attention to where process improvement is needed, and red stands out much more against neutral colors than when there are other colors next to it.

For your consideration 🙂

The pbix with examples is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[spagad6263]

Btw, I remember you have answered quite a few of my questions and the they really help! Much appreciate your advice.

[Ritaf1983]

Happy to help 🙂

[spagad6263]

Thanks for the quick reply. I will give it a try. Thanks

[ryan_mayu · Accepted solution]

@spagad6263 

you can try to use conditional formatting in table visual

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting?wt.mc...