Can't see the summarization option in conditional formatting

[ayushqralgroup]

Hi,

I am trying to create a conditional formatting rule based on the count of a Text field. The problem is that I am not able to select that text field and also don't see the "Summarization" drop down (which I saw in earlier versions of PBI). Could someone please help?

[Anonymous]

Having same exact issue here. I could see the summarization option up till a few days ago and if I open a previous version of the same pbix file it works fine. The only difference between the two versions is that I added a calculation item from Tabular Editor recently. Not sure if this change is causing the odd behaviour in the conditional formatting pane and if it isI can't see any direct correlation between the two components.

[ayushqralgroup · Accepted solution]

I couldn't find the exact cause but copying my changes in another PBIX solved this. Looks like some PBIX file related issue but not exactly sure what.

[ayushqralgroup]

Hi @Pragati11 ,

Below is how I am doing it:

 When I select the text field, it just doesn't show up in the "What field should we base this on?" drop down, and it turns to a red border

[Pragati11]

HI @ayushqralgroup ,

I might not be clear in my lats response, but I am trying to understand on what field are you applying conditional formatting in the visual like i the below screenshot I have Product Line column which is on my visual:

Also if this is still an issue, can you please share your Pbix file by removing any sensitive information from it?

You can use Dropbox or WeTransfer to share the pbix.

[Pragati11]

Hi  @ayushqralgroup ,

What version of Power BI are you working with?

I tried to apply background conditional formatting to one of my columns and I see the right formatting options. I am applying conditional formatting on Product Line column here which is a text column.

Can you share more details here please like PBI dektop version, on which type of column you are trying to apply conditional formatting?

[ayushqralgroup]

Hi @Pragati11 ,

I am using: Version: 2.114.864.0 64-bit (February 2023)

The column is a Text Column with simple "Yes" or "Blank" values. The Summarization on the column setting is set to "Don't summarize" and Data Category is "Uncategorised". Please refer to the images below:

[Pragati11]

HI @ayushqralgroup ,

Can you also show how you are applying coinditional formatting please?