Conditional formatting

[akash0800]

Hi,

Need your help on a scenario.

I have table visual that displays clients, projects and revenue for quarter. Now I want to have a yellow background for each entry that is more than x% greater/lesser than same quarter last year. And background Red when blank.

 

Your ideas will be of great help.

Thanks,

Akash

[djurecic · Accepted solution]

Hi @akash0800 ,

 Create a measure that calculates the difference from last year. Then use Rules to set the colors including red.

Here is more information:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color...