Conditional Formatting in my Table Disappears when I add a Column

Question

Hello,I have a report with a table where I need to highlight some values based on another field.&nbsp; The conditional formatting works as expected until I add another column to the table, then the conditional formatting is not being applied to values without a values in the new column.&nbsp;I need to highlight (text in red) the sizes that are unavailable.&nbsp; Both XX-Large and XX-Small are highlighted as I want in the left table.&nbsp; When I add the count of sales to the table, the XX-Small is still red, but XX-Large, which has no sales, loses its conditional formatting.&nbsp;&nbsp;How can I make it stay red?&nbsp;My report is available here:&nbsp;https://www.dropbox.com/scl/fi/kaehipx737w9528mh8cy9/Conditional-formatting.pbix?rlkey=x31ivvj3450rjt9jrvm3dihxr&amp;dl=0&nbsp;Thank you!&nbsp;&nbsp;

kaviraj11 · Accepted Answer

I tried at my end and I would suggest you to create a measure of Count of Sales and utilize it in the table that will resolve your issues.Count of Sale = COUNT(Sales[Sale])+0&nbsp;&nbsp;&nbsp;

Forum Discussion

Conditional Formatting in my Table Disappears when I add a Column

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting