Forum Discussion
conditional formatting on % not working in table visualization
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.
Solution SageHi
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
Hi, I did that technically by putting in numbers between 0 and 1 as green, and numbers between -1 and 0 as red. Is that what you meant?
- 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
Hello, I did not multiply the calculation by 100, I simply marked the measure as a data type of Percentage. Therefore, 1 should be 100% and -1 should be -100%. Right?
I'm also confused too, because i thought I did have the most up to date version of Power BI. But I will double check.
