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 August 31st. Request your voucher.

Reply
SriniMunagala
Regular Visitor

Fix measure color in dynamic column selection

Hi,

I'm working on dynamic column selection on a Clustered Column chat.

I'd like to fix the column colors (eg: no matter what the selection is Failure should always be red).

But when I do single selection they always show same color(here it's blue).

Sharing the attachment here.

Could you please help how to achieve this.

I'm not able to upload the PBIX file here. Will share it through other means, if some one needed.

 

SriniMunagala_0-1670521326472.png

 

SriniMunagala_1-1670524801075.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @SriniMunagala ,

I can't reproduce your problem, the .gif below is my testing result and the attachment is the related pbix file. The version of my Power BI Desktop is 2.111.590.0 64-bit (November 2022). Could you please provide some raw(fake) data in your tables (exclude sensitive data) with Text format, your cluster column chart settings and the related formula if you involve any measure on your column chart. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Fix measure color in dynamic column selection.gif

Best Regards

View solution in original post

4 REPLIES 4
SriniMunagala
Regular Visitor

Thank you, it worked. 🙂

SriniMunagala
Regular Visitor

Thank you Sir for the response. The slicer is not having the values of a measure but they are three different measures. So, it became complicated. Here is the link for PBIX .

TestPBI.pbix

 

Please help.

Anonymous
Not applicable

Hi @SriniMunagala ,

I updated your sample pbix file(see Page 1 in the attachment), please check if that is what you want. You can update the Columns color formatting as below screenshot: Format style--> RulesWhat filed should we base this on? --> Sum of RunFilter Order

yingyinr_0-1670813409263.png

Best Regards

Anonymous
Not applicable

Hi @SriniMunagala ,

I can't reproduce your problem, the .gif below is my testing result and the attachment is the related pbix file. The version of my Power BI Desktop is 2.111.590.0 64-bit (November 2022). Could you please provide some raw(fake) data in your tables (exclude sensitive data) with Text format, your cluster column chart settings and the related formula if you involve any measure on your column chart. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Fix measure color in dynamic column selection.gif

Best Regards

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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