Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tloewen98
Frequent Visitor

Filter a column on table by the font color

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. 

tloewen98_0-1656076957691.png

 

Thanks for any help and response!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

2 REPLIES 2
tloewen98
Frequent Visitor

@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
Super User
Super User

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors