Hi All,
I am setting up conditional formatting in power for a measure, i set up the rules but the values are not following the rule. I want negative numbers as red and positive numbers as green.
Also, I want to confirm, if the user export the table, would the colors be exported with the table
Kindly help.
Hello @wilford.mitchell, and thank you for starting a conversation on the Community Forum. Would you please add your work-in-progress Power BI Desktop file, as well as your source data file in Excel format. This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
Hi @wilford.mitchell. No, colours are not exported. Greg
Try setting you “green” rule to >=0 and <=max
Rules aren’t well documented and are frankly rather confusing. A better method imho is calculating a measure that conditionally returns color hex values and then uses that field in the color fx rather than setting rules.
