Fix measure color in dynamic column selection

[SriniMunagala]

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]

Thank you, it worked. 🙂

[SriniMunagala]

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.

[v-yiruan-msft]

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--> Rules,  What filed should we base this on? --> Sum of RunFilter Order

Best Regards

[v-yiruan-msft · Accepted solution]

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

Best Regards