Conditional Formatting not working on Interactive Bar Chart

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> )