Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
In my PowerBi report, I have added a guage chart, and applied conditional formatting, based upon 2 values:
If the actual value is more than target, then the gauge chart will be green otherwise red. Now, based upon the data selected in a multi select drop down, the values of both 'Target' and 'Actual value' changes. Therefore, I want to have a dynamic conditional formatting for the guage chart where the conditional formatting for color is applied correctly according to different targets and their respective actual values.
For example:
Target; | Actual Value; | Color of Chart |
85 | 84 | Red |
77 | 79 | Green |
65 | 71 | Green |
However, as displayed in the attached screenshot, the highlighted box expects a hardcoded numeric value. Please advise how to achieve this. Thanks in advance.
Solved! Go to Solution.
Hi @v-ankitgupta ,
Please try:
Color = IF(SUM('Table'[Actual Value;])>SUM('Table'[Target;]),"Green","Red")
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-ankitgupta ,
Please try:
Color = IF(SUM('Table'[Actual Value;])>SUM('Table'[Target;]),"Green","Red")
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A very belated thank you for posting this, works like a dream!
It worked Jianbo, Thank you very much.
User | Count |
---|---|
98 | |
76 | |
75 | |
48 | |
26 |