Forum Discussion
conditional formatting on % not working in table visualization
I've seen posts about this before, but none of the solutions worked for me. I am trying to change the background color to have the negative percentages to show as red and the positive percentages to show as green. I tried doing this & nothing happens:
Hi Anonymous ,
Please try to install a latest Power BI Desktop. https://www.microsoft.com/en-us/download/details.aspx?id=58494
I try what you did and it works fine in my sample. You could download it to have a try.
9 Replies
nvprasadSolution Sage
Hi
Try in % where input numbers in decimal points. Ex: write 0.7 instead of 70%.
Appreciate a Kudos!
If this helps and resolves the issue, please mark it as a Solution!Regards,
N V Durga Prasad- amitchandak
Super User
Anonymous , if you mark the column as % column 1 means 100 %. If you have multiple by 100 it mean 100 is 100. So based on that put your condition.
Also is it the latest version, there should be an option for percent and Number too in rules
Syndicate_AdminAdministrator
The color format works when it is number but if you have applied the percentage does not work
