Forum Discussion

Back2Basics's avatar
Back2Basics
Icon for Resolver I rankResolver 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.

Back2Basics's avatar
Back2Basics
Icon for Resolver I rankResolver I
4 years ago

Hi MFelix 

 

I succesfully used this, as I've said, in a report - worked perfectly. However, the report became corrupted and I had to start again. I did exactly the same, everything is as your suggestion - but for some reason the conditional formatting will not function this time round. 

It's not essential that the report has this but it is a very useful function. Do you know of any reason, or setting, that might mean this wouldn't work for one report when it does work in an identical report?

MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 years ago

Hi Back2Basics,

 

The questions here can be of context or filtering. But without any specific information is difficult to pin point.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.