Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Formatting on a text field based on Slicer selections from a separate dataset

Hello,   I am trying to "highlight" the background of each item that falls under a specific category of a slicer. The slicer however comes from a separate dataset i.e. the items come from one data...
Need Help
Show and Tell
Tips and Tricks
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, Anonymous 

Do you mean that these two tables are not directly related to each other?

Is it convenient to show the view of the relationship between your table and the table (using the option insert photos)?

Ex:

 

Best Regards,
Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-easonf-msft ,

 

Yes, both tables are not directly related to each other.

 

All the relationships are not able to fit into one picture but I will post them, hopefully you can follow.

 

123

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , Anonymous 

    Try measure as below :

    Measure1 =
VAR _cotc =
    CALCULATETABLE (
        VALUES ( 'Brands&COTC'[COTC] ),
        FILTER (
            ALL ( 'Brands&COTC' ),
            'Brands&COTC'[COTC] IN FILTERS ( Slicer[slicer_COTC] )
        )
    )
VAR _sku =
    CALCULATETABLE (
        VALUES ( 'Brands&COTC'[SKU Desc] ),
        FILTER ( ALL ( 'Brands&COTC' ), 'Brands&COTC'[COTC] IN _cotc )
    )
VAR _skureflect =
    CALCULATETABLE (
        VALUES ( 'Brand&SKU'[Description] ),
        FILTER ( ALL ( 'Brand&SKU' ), 'Brand&SKU'[SKU Desc] IN _sku )
    )
VAR _description =
    CALCULATETABLE (
        VALUES ( 'Data Table'[Customer ID] ),
        FILTER ( ALL ( 'Data Table' ), 'Data Table'[Description] IN _skureflect )
    )
RETURN
    IF ( MAX ( 'Data Table'[Customer ID] ) IN _description, 1, 0 )

    Then apply it to background conditional formatting.

     

     

     

     

    pbix attached

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello v-easonf-msft ,

       

      Thank you for your solution.

       

      It first highlights all Item Descriptions when no filter selections are made. When COTC Slicer is applied, only those Item Descriptions which fall under that category are highlighted.


      Also, I am not able to mark your answer as the solution because "Authentication Failed" error occurs.

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi, Anonymous 

        It first highlights all Item Descriptions when no filter selections are made. When COTC Slicer is applied, only those Item Descriptions which fall under that category are highlighted.

         

        Sorry, I am not able to  understand what you mean.
        Has your problem been resolved? If there is something that does not meet your expected results, can you explain it in more detail.

         

        Best Regards,
        Community Support Team _ Eason