Forum Discussion
Power BI - Gauge- Conditional formatting
Hi,
I am trying to have a gauge that changes color based on conditional formatting. Right now I have this:
with this measure:
6_Difference_PO = DIVIDE(([AllOpenWO] - [Open_WO_Older_Than_6_Months]), [AllOpenWO], 0)
and the conditional formatting that I have for the Gauge is:
which is not working as I would like for it to be blue when is between 90 and 94 %
Green when is between 95 and 97 %
purple for when is 98 to 100 %
and red between 0 to 89 %
What is the reason that this is not working and how can it be fix? Is there any other option?
Any help most appreciated.
Thank you.
purple for when is 98 to 100 %
and red between 0 to 89 %
What is the reason that this is not working and how can it be fix? Is there any other option?
Any help most appreciated.
Thank you.
you'll need to change the numbers -
e.g. for 94%, use the number 0.94 instead.
2 Replies
you'll need to change the numbers -
e.g. for 94%, use the number 0.94 instead.