Forum Discussion
Conditional Formatting not working on Interactive Bar Chart
Hi all,
I am Izzuddin, new to Power BI.
I would like to ask on how to make conditional formatting applied in interactive clustered column chart.
I already did conditional formatting on the value of the chart, without interactive selection, the conditional formatting is worked as below. Conditional formatting requirement is 0 >= Red color < 99.99% & 99.99% >= Green color <= 100%.
Seek advice for all and have a very nice day.
Thanks.
OK - Chart without interactive selection (Correct color)Applied rulesNOK - Chart with interactive selection (Incorrect green color)
Hi Izzuddin
If you want the bars to be formatted based on the actual value of each bar, in the conditional formatting dialog box you should use decimal values and "Number" (rather than "Percentage").
See here.
In this case, you should use
- If value >= 0 Number and < 0.9999 Number
- If value >= 0.9999 Number and <= 1
With the "Percent" option, the Percent values are converted to numbers by interpolating linearly between the Min and Max values visible on the visual, with Min treated as 0% and Max treated as 100%. Effectively using the formula:
- Number = <Min value visible> + Percent/100 * ( <Max value visible> - <Min value visible> )
2 Replies
Hi Izzuddin
If you want the bars to be formatted based on the actual value of each bar, in the conditional formatting dialog box you should use decimal values and "Number" (rather than "Percentage").
See here.
In this case, you should use
- If value >= 0 Number and < 0.9999 Number
- If value >= 0.9999 Number and <= 1
With the "Percent" option, the Percent values are converted to numbers by interpolating linearly between the Min and Max values visible on the visual, with Min treated as 0% and Max treated as 100%. Effectively using the formula:
- Number = <Min value visible> + Percent/100 * ( <Max value visible> - <Min value visible> )
