Forum Discussion
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]RETURNSWITCH (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-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=
4) Go to conditional formatting,select measure3 in rules and select value 1 and 2 for red .
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