Conditional Formatting a table: can someone confirm it's me?

[PaulDBrown]

Hi everyone,

I hope you and your family and friends are all safe and healthy in these difficult times.

I have suddenly come across a problem trying to format a table conditionally, and I really cannot work out what is wrong (probably something pretty dumb, but I can't "see" the issue. Basically I'm trying to format a value conditionally (I've tried backround colour, font colour and icons...) but there seems to be a problem, since the function only seems to recognise the first parameter. If this parameter isn't met, then the subsequent formatting seems to be ignored. (not sure if it a bug)

Here is a screenshot:

Can aynone shed any light?

Thanks.

[v-lili6-msft · Accepted solution]

hi  @PaulDBrown 

Please refer to red part of this document:

Considerations and limitations

There are a few considerations to keep in mind when working with conditional table formatting:

• Conditional formatting applies only to the values of Table or Matrix visuals, and doesn't apply to any subtotals, grand totals, or the Total row.
• Any table that doesn't have a grouping is displayed as a single row that doesn't support conditional formatting.
• You can't apply gradient formatting with automatic maximum/minimum values, or rule-based formatting with percentage rules, if your data contains NaN values. NaN means "Not a number," most commonly caused by a divide by zero error. You can use the DIVIDE() DAX function to avoid these errors.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#considerations-and-li...

Regards,

Lin

[Pragati11]

HI @PaulDBrown ,

Is there any default filter on your dashboard that is displaying only one value?

Can you share your .pbix file?

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati