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,

 

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

 

  • MFelix's avatar
    MFelix
    Super User
    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.

    • Back2Basics's avatar
      Back2Basics
      Resolver I
      4 years ago

      That is great, thanks. Worked a treat. 

      I've not done much with measures, so getting help like this goes a long way for me. Thanks