Conditional Formatting, Adding a graphic

[petermb72]

My supervisor would like to have a check added to an area if a certain metric was being met.  Is there a way to add a graphic based on if the goal or metric is met? Idealy it would be great to do a red checkmark if not met and then turn it green if it is.  Also one other thing is that there would be multiple of these measures on one page.

Thanks,

Peter

[Icey · Accepted solution]

Hi @petermb72 ,

Please check if this is what you want:

Method A:

1. Create a conditional measure.

Measure = IF([Sum]>30,1,0)

2. Set conditional formatting of [Sum] card visual.

Method B:

1. Create a conditional measure:

Measure 2 = IF([Sum]>30,"#FFFFFF00","White")

2. Set background color of a card visual.

3. Insert one Image and put the image behind the card above.

Then, you can get this:

Best Regards,

Icey

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

[amitchandak]

refer:https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

https://powerbi.tips/2019/07/icons-upon-icons/

[petermb72]

I was thinking more of a Graphic conditionally appearing on the page based on meeting the criteria.  Your option would be fine if the data was being presented in a table.

[amitchandak]

If you want visual to show hide based on condition then bookmark is the option

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[petermb72]

I read the artical, it looks to me like you would need to choose to show the checkmark or not.  I am looking for a checkmark to appear if the bar grap goes over 80% (an example).