Conditional Formatting

[Anonymous]

Hello,

Thought this would be easy, but couldn't get done. Is there a way to do this :

Sales data - Actual and Plan is currently stored in database as below :

Month	Actual	Plan
01/01/2021	1000	1500
02/01/2021	800	750
03/01/2021	900	800

We are looking for a Matrix in Power BI that displays as below :

If the Actual is lesser than Plan, then should be displayed in Red or else in Green

	01/01/2021	02/01/2021	03/01/2021
Actual	1000	800	900
Plan	1500	750	800

[VijayP]

@Anonymous 

You need to aggregate Actual and Plan and compare with each other

IF(Sum(Actual)<Sum(Budget),"Red","Green") should work.

Let me know if any assistance required

[Anonymous]

Thank you @EVIJ !

Actually, it looked bit more complicated, may be I should have explained more. Thanks for the suggestion !!

[Angith_Nair]

Hi @Anonymous 

Try with this measure and in conditional formatting use this measure as a field value..

Measure = 
IF( SELECTEDVALUE('Table'[Actual]) < SELECTEDVALUE('Table'[Plan]), "#d40d1a", "#0dd42b")

It will look something like this..

If this helps, kindly mark it as a solution. Appreciate with Kuddos.

[Anonymous]

Thank you Angith !

But, the catch is, the Actual and Plan should be displayed as rows and not columns. They must be pivoted. Can this be still achieved ?

[Angith_Nair]

I am not sure about this. @amitchandak sir, is this can be achieved..?