Conditional Formatting 'What field should we base this on?" reverts to blank

[PeteMcColl]

I have an issue with conditional formatting in my Power BI Desktop Project.

When I go to conditional formatting for any field within my table visual, the "What field should we base this on?" reverts to blank no matter what field I select.

This happens regardless of the format style I choose or the column I base it on.
I tried adding new table visuals and used different columns to see if this would work, but it sadly doesn't.

I have tried in other projects and this works fine, but I will note that my columns don't have any implicit measures when I select them in the visualizations pane. There are no calculation groups in this project.

[OwenAuger · Accepted solution]

Hi @PeteMcColl 

It looks like "Discourage implicit measures" may be enabled even if there are no calculation groups in the model. Can you check the model view, and if it is enabled you can try disabling it:

https://learn.microsoft.com/en-us/power-bi/transform-model/model-explorer#discourage-implicit-measur...

This can happen if the model previously included a calculation group (which forcibly enables Discourage implicit measures) but the calculation group was later removed (which doesn't automatically disable Discourage implicit measures).

The alternative is to create and use explicit measures as the basis for conditional formatting.

[PeteMcColl]

Hi Owen,

Thanks for your help. This was the issue, and after unticking the 'Discourage Implicit Measures' option I was able to use conditional formatting again.

Cheers