Forum Discussion

atul9063's avatar
atul9063
Helper III
7 years ago
Solved

Conditional formatting based on dropdown change

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                                         ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • atul9063's avatar
    atul9063
    7 years ago

    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's avatar
v-lili6-msft
Community Support
7 years ago

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's avatar
    atul9063
    Helper III
    7 years ago

    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's avatar
      v-lili6-msft
      Community Support
      7 years ago

      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