Forum Discussion

Back2Basics's avatar
Back2Basics
Resolver I
4 years ago

Conditional formatting DAX

I'm trying to add some conditional formatting to a matrix. I have a matrix that has a series of outcomes and the count of Unique_ID for each outcome. I also have a dropdown on the page so that users can select an ID and the matrix highlights the outcomes for that particular ID - this is working fine using the following DAX: 

Matrix select = IF(ISFILTERED('Report measures'[Unique ID]),IF(SELECTEDVALUE('Report measures'[Unique ID]) IN VALUES (Workbook[Unique ID]), 1))

& then applying the appropriate conditional formatting. 

I also have a table which has a list of 'linked' ID's. So this looks something like this:

Unique IDLinked ID
INT001INT172
INT001INT250
INT002INT015

 

I want to replicate the matrix that is working, as described above, so that when an ID is selected it highlights the outcomes for the Linked ID's. I have been trying several things but just can't quite get it to work. Everything is still assocaited with the Unique ID filter rather than filtering the Linked ID. 

Any help is very much apprecaited.

5 Replies

    • Back2Basics's avatar
      Back2Basics
      Resolver I
      4 years ago

      Hi tamerj1 - yes, there is a relationship between the Unique ID columns in each table. The table with the linked Id's is standalone, so could remove the relationship if this is the way to do it

       

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Back2Basics 
        I'm having some difficulties replicating your matrix. Would you please provide some sample data and perhaps some screenshots to understand exactly what is required. Thank you