Hi Dear Community,
I am trying to set up a conditional formatting for a table visualization and a measure by using Rules conditional formating on measure values however the formating does not follow the set up I created.
Based on the conditional formatting set up, font color should follow the following logic on the print screen, however in practice the font colors do not match with the Rules, e.g. only values over 30 % should be red but as you can see 25 and 24 % are also red etc.
Do you know the solution to resolve the issue by any chance?
Thank you,
Adam
1 ACCEPTED SOLUTION
Problem is solved. Instead of using 20 Percent etc. I changed it to 0.2 Number and it worked. The underlying measure based on which I apply the conditional formatting is %.
Thank you for your help.
Problem is solved. Instead of using 20 Percent etc. I changed it to 0.2 Number and it worked. The underlying measure based on which I apply the conditional formatting is %.
Thank you for your help.
The left part you selected is Percent and the right part you selected is Number. Please update the selection to be the same.
Hi @ryan_mayu, thank you for your help, you are right, I have corrected it, however it is still really strange:
Myanmar, Indonesia, Mongolia between 10 and 20 % did not get soft orange color.
Also Malaysia and Timor Leste got red color but based on their value of 24 and 25 % there should be dark orange as dark orange is set for percentagees between 20 and 30 %.
Have you ever experienced something like this before with Power BI?
Thank you for your help in advance,
Adam
