Forum Discussion
Conditional Formatting, Adding a graphic
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
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.
5 Replies
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.
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
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.
