Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
StaceyGriffeth
Helper II
Helper II

Conditional Formatting drops when another field added to table

I'm experiencing something strange.  I have a table with a column for "CoDescription", coming from the Report Configuration table:

StaceyGriffeth_0-1644886636651.png

 

I have applied conditional formatting like below:

StaceyGriffeth_1-1644886669320.png

StaceyGriffeth_2-1644886704227.png

However, when I add another column to the table, while the column populates, the conditional formatting for the original column disappears:

StaceyGriffeth_3-1644886760456.png

I have built numerous reports with this structure (using a separate report config document, conditional format, adding additional columns), and never had this happen before.  Does anyone have any ideas?

 

Thanks!

  

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @StaceyGriffeth ,

Could you pls share your  Co_01 ? 

Based on the data you have provided so far, no matter how I add columns, and create my own Measure, it will not affect the formatting.

vluwangmsft_0-1645169469181.png

 

And could you pls share your pbix file ,and remember to remove confidential data.

 

 

Best Regards

Lucien

jaipal
Resolver III
Resolver III

@StaceyGriffeth  change summarization to Count and check.

Hi @jaipal I can't change CoDescription to be count summarization or it does not show the description.  The next column "Co_01" is actually a measure (a lengthy switch statement), so summarization does not apply.  Do you have any other ideas?

 

Thanks!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.