Particular cell color based on month slicer

[NadeemAhamed]

Dear Community.

I am trying to apply background color for particular row cell based on selected month slicer. (Apr to Mar)

Color: Light Green

Ex: 

If user has selected month 

Month: Apr

Particular Cell : Division:Admin 

Month: May

Particular Cell : Division: IT 

Month: Jun

Particular Cell : Division : Transport

....... till Mar Particular Cell will be going to change. 

applying row cell is possible through DAX but i am not getting how to apply color condition with multiple if condition where one by one if condition should be execute. 

Thank you in adavance. 

[NadeemAhamed]

@Ritaf1983 

Thank you for your valuable time to read and respond

Here i have attached the excel and pbix file for your reference. 

pbix : https://toyotsu.box.com/s/e034h1r83v4h37weej7hwgpurpb1b100

excel : https://toyotsu.box.com/s/s3f7z18rwbze0kauuzobz6u2u564fw2l

In excel where ever cell has colored similary i have to color the cells in power bi table or matrix based on month slicer. 

[Ritaf1983 · Accepted solution]

Hi @NadeemAhamed 
You can create DAX like below (note that I did it on the part of the months to show how it works + you need 2 measures one for plan and second for actual) :

plan color =

SWITCH(SELECTEDVALUE(Sheet1[Month ]),

"apr" ,

if(SELECTEDVALUE(Sheet1[Divison])= "Admin" , "Light Green","White"),

"May",

if(SELECTEDVALUE(Sheet1[Divison])= "IT" , "Light Green","White"),

"Jun",

if(SELECTEDVALUE(Sheet1[Divison])= "Tech park Dev" , "Light Green","White"),

"Jul",

if(SELECTEDVALUE(Sheet1[Divison])= "Admin" , "Light Green","White"),

"White")

Result:

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[NadeemAhamed]

@Ritaf1983 

Is it possibile to apply the condition to two or three rows?

[Ritaf1983]

Hi @NadeemAhamed 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly