show icon

[NewbieJono]

i have a % diffrence. if it is minus i would like to show it as green and if it is + i would like to show it as Red.

how do i go about this?

[sirlanceohlott]

Hey @NewbieJono ,

You can achieve the desired effect using conditional formatting in a table or matrix visualization.

Here's the documentation for conditional formatting in Power BI Desktop: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

If you'd like this effect achieved in a card visualization, I'd suggest using one of the custom card visualizations you can find in the AppSource marketplace.

My personal favorite is Cards with States by OkViz.

[selimovd · Accepted solution]

Hey @NewbieJono ,

in a matrix or table you can do that easily with conditional formatting.

Check the following article on how to do that:

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic