Forum Discussion
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...
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:
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.
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.