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.
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?
Super UserAnonymous , 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.
I tried your suggestion to multiply by 100 & it did not work.
This is the version of Power BI I have: