Conditional formatting based on dropdown change

[atul9063]

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

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

[v-lili6-msft]

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

basic tablemapping 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:

Result:

Best Regards,

Lin

[atul9063 · Accepted solution]

@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 .

[v-lili6-msft]

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