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

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

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 .

3 Replies

  • 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