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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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