Forum Discussion

vgeldbr's avatar
vgeldbr
Icon for Helper IV rankHelper IV
5 years ago
Solved

Conditional formatting of a Slicer background

I wish to have a slicer background change colour to make it really obvious when there is a slicer value selected. I have created the measure: Slicer Color 2 = IF( ISFILTERED ('ITRDB Daily_Pro...
Need Help
  • vgeldbr's avatar
    vgeldbr
    5 years ago

    Thanks amitchandak . I've opted simply to put a conditionally formatted shape behind the slicer to achieve a similar effect. This works.

ColinRE's avatar
ColinRE
Icon for Helper I rankHelper I
2 years ago

This is painful. 1700 views later. I wonder if using the value from the slicer to feed the conditional coloring cannot be evaluated on itself? 

PBI_Queryous's avatar
PBI_Queryous
Icon for Advocate I rankAdvocate I
2 years ago

I believe its futile, because the slicer does not recognise row context on itself, so when you choose a value, it cant tell if the selected value of the slicer is filtered or not. 

 

It's a sad state of affairs. File this one under pure neglect.