cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cubist Regular Visitor
Regular Visitor

Can conditional formatting work without summarization?

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-

3 REPLIES 3
Sean Super Contributor
Super Contributor

Re: Can conditional formatting work without summarization?

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

 

Conditional Formatting.png

Cubist Regular Visitor
Regular Visitor

Re: Can conditional formatting work without summarization?

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

LisbethSchoman Frequent Visitor
Frequent Visitor

Re: Can conditional formatting work without summarization?

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.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 221 members 2,393 guests
Please welcome our newest community members: