Reply
Highlighted
Member
Posts: 45
Registered: ‎02-26-2018
Accepted Solution

Conditional formatting based on dropdown change

[ Edited ]

Hi,

In below requirement,

If select India>5M then India column value should highlight red 

If select USA>1M then USA column value should highlight red

image.png                                                                          Is this possible to select conditional filter in dropdown and display conditional formatting based on that?           


Accepted Solutions
Member
Posts: 45
Registered: ‎02-26-2018

Re: Conditional formatting based on dropdown change

@v-lili6-msftI have solved this problem.

 

 

1) I have created dimsion table Country, with India>5M and USA>1M as values

 

2) I have created two measures

measure1=VAR HAPP1 = VALUES(Table1[India]) RETURN IF ( ABS(HAPP1 ) > 5000000 ,1)

 measure2=VAR HAPP2 = VALUES(Table1[Americ]) RETURN IF ( ABS(HAPP2 ) > 1000000 ,2)

 

3) Then i have created third measures which will call above two measures

measures3=

VAR selection  =
[CheckSelected]
RETURN
SWITCH (
TRUE (),
MySelection = "India>5M",[measure1] ,
MySelection = "USA > 1M", [measure2],
BLANK())

 

4) Go to conditional formatting,select measure3 in rules and select value 1 and 2 for red .

View solution in original post


All Replies
Community Support Team
Posts: 1,131
Registered: ‎07-30-2018

Re: Conditional formatting based on dropdown change

hi, @atul9063

After my test, you could this way as below:

Step1:

Create a highlight table map to region field (USA, India, etc.) of basic table

For example

7.JPGbasic table8.JPGmapping table

Note: Do not create a relationship between them

 

Step2:

Create a measure like this

Measure = IF(SELECTEDVALUE('Table 2'[Type])=SELECTEDVALUE('Table'[Type]),1)

Step3:

Set Conditional formatting like below:

9.JPG

Result:

10.JPG11.JPG

Best Regards,

Lin

 

 

Attachment
Member
Posts: 45
Registered: ‎02-26-2018

Re: Conditional formatting based on dropdown change

@v-lili6-msftI have solved this problem.

 

 

1) I have created dimsion table Country, with India>5M and USA>1M as values

 

2) I have created two measures

measure1=VAR HAPP1 = VALUES(Table1[India]) RETURN IF ( ABS(HAPP1 ) > 5000000 ,1)

 measure2=VAR HAPP2 = VALUES(Table1[Americ]) RETURN IF ( ABS(HAPP2 ) > 1000000 ,2)

 

3) Then i have created third measures which will call above two measures

measures3=

VAR selection  =
[CheckSelected]
RETURN
SWITCH (
TRUE (),
MySelection = "India>5M",[measure1] ,
MySelection = "USA > 1M", [measure2],
BLANK())

 

4) Go to conditional formatting,select measure3 in rules and select value 1 and 2 for red .

Community Support Team
Posts: 1,131
Registered: ‎07-30-2018

Re: Conditional formatting based on dropdown change

hi, @atul9063

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Best Regards,

Lin