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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Anonymous
Not applicable

Conditional Formatting in Table not working for some rows

I am having trouble with a table in my report. I set up a conditional formating for the title coulumn based on a True/False column converted to to 1/0 to show red when that value is 1 and to do nothing when the value is 0. It is working fine, except on a few rows. The table in question has a title field, the formated field, and two number fields counting related records from two other tables. For rows where there are no related records, resulting in a null on the count fields, The conditial formating does not display. The titles field and the field the formating is based on come from the same table so they do not rely on any relationships with the count columns.

 

I did test what happens without the count columns. If I remove the other columns from the table, leaving just the title, the formating works flawlwssly. However, I want those counts to be there as one column tables are not the most useful things out there. 

 

Why would that formating not show on the rows with nulls when the nulls are completely unrelated to the formating?

 

 

1 REPLY 1
Anonymous
Not applicable

I see over 100 views and no replies. So I am wondering, is there any more clarification I could give that might help someone answer this? I as still stumped on this issue myself. 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

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

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.