Can conditional formatting work without summarization?

Question

It seems that the "Conditional Formatting" option is only available for a value if it is aggregated (summarized).

Am I undertstanding correctly?

Is there any reason for this limitation?

thank you-

anonymous · Answer

You need NO AGGREGATION at all, and conditional formatting based on Non-Numeric values, and preferably not a gradient assignment but rather assign colors to values instead.&nbsp; This is sorely missing from Power BI

sean · Answer

You can get around this by having an Index (or use another Column has a value at each row) and inlcude that Index in the Visual

Then the Values will not be really aggregated (although they'll default to SUM)

But the option will be available for Conditional Formatting

cubist · Answer

Thanks, not sure why this is disallowed but that's a good workaround.

lisbethschoman · Answer

I found out, that if you use summarize when you format, then you can deselect summarize again after you have formatted.Strange.... but for me it works.

Forum Discussion

Can conditional formatting work without summarization?

4 Replies

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting