Forum Discussion

Back2Basics's avatar
Back2Basics
Resolver I
4 years ago
Solved

Maxtrix conditional formatting

I have a matrix that is using data from two tables. Both tables have two columns; 'Unique ID' plus either 'Action' or 'Outcome'. Both of the tables have multiple rows per ID as each Id can have many...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi Back2Basics ,

     

    Believe that for this case you need to create a unrelated table with the unique ID's then you need to create a measure similar to this one:

    Condittional formatting = IF(SELECTEDVALUE(SlicerID[ID]) in VALUES(UniqueID[ID]), 1)

     

    Now on the condittional formating select rule and value equal 1 should give something similar to:

     

     

     

     

  • MFelix's avatar
    MFelix
    4 years ago

    Hi Back2Basics ,

     

    That is related with the fact that probably those lines include all values on the slicer.

     

    Try to change your measure to:

     

    Condittional formatting =
IF (
    ISFILTERED ( SlicerID[ID] ),
    IF ( SELECTEDVALUE ( SlicerID[ID] ) IN VALUES ( UniqueID[ID] ), 1 )
)

     

    This will make sure you have selections on the slicer.

MFelix's avatar
MFelix
Super User
4 years ago

Hi Back2Basics ,

 

Believe that for this case you need to create a unrelated table with the unique ID's then you need to create a measure similar to this one:

Condittional formatting = IF(SELECTEDVALUE(SlicerID[ID]) in VALUES(UniqueID[ID]), 1)

 

Now on the condittional formating select rule and value equal 1 should give something similar to:

 

 

 

 

  • Back2Basics's avatar
    Back2Basics
    Resolver I
    4 years ago

    Thanks MFelix this is great. One thing that is a little annoying is that the matrix has a default formatting, with seemingly random cells getting the background - but works perfectly once the slicer has been selected. 

    • MFelix's avatar
      MFelix
      Super User
      4 years ago

      Hi Back2Basics,

       

      What do you mean randomly get background? 

      • Back2Basics's avatar
        Back2Basics
        Resolver I
        4 years ago

        When nothing is selected from the slicer, there are some cells that have a background coloured already. But I'm unsure what they are relevant to