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.
|Target;||Actual Value;||Color of Chart|
However, as displayed in the attached screenshot, the highlighted box expects a hardcoded numeric value. Please advise how to achieve this. Thanks in advance.