Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter based off conditional format colours

Is it possible to filter by colour / add a slicer to filter by colour on table that has conditional formatting on? i.e. I have a row of reds and greens based off of positive and negative figures -...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi , Anonymous 

Please follow these steps: 

1.create a measure and apply it to "font color conditional formatting。

 

color formatting = IF(SELECTEDVALUE('Table'[Data])<0,"green","red")

 

 

 

2.create another calculated table as below:

 

Slicer table = DATATABLE("Value",STRING,{{"All"},{"red"},{"green"}})

 

3. create a table control visual as below ，then apply it to visual filter pane

 

Visual control = 
SWITCH (
    SELECTEDVALUE ( 'Slicer table'[Value] ),
    "green", IF ( SELECTEDVALUE ( 'Table'[Data] ) < 0, 1, 0 ),
    "red", IF ( SELECTEDVALUE ( 'Table'[Data] ) > 0, 1, 0 ),
    1
)

 

For more details,please check attached  pbix file.

 

Best regards,

Eason