Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
refer:https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
https://powerbi.tips/2019/07/icons-upon-icons/
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
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |