Filter a column on table by the font color

[tloewen98]

I have a table that I have created inside of powerbi Desktop. I have added a dax formula to add font color based on a calculation. Now that I have the different color text in my table, I want to be able to add a filter that will allow me to filter the entire table based on the font color of one row. 

Thanks for any help and response!

[tloewen98]

@amitchandak Thank you for the response. I used a column to achieve this result and I was able to drag it over to the slicer box and it worked. I am still new to Powerbi and still trying to learn as much as possible! Thank you so much!

[amitchandak · Accepted solution]

@tloewen98 , If you have created a column for the column, you can use that in the slicer filter.

If you have created a table then you need to create an independent table with the color name and join it with the color measure and create a filter

refer Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ