Reply
hoosha_11
Helper I
Helper I

Bar Color Change in drill through page

Hi,

 

In a clustered column chart, we have many legends, each represented by a different color. But, since I am using a bar chart on a drill-through page, it will only display one legend when a user selects an item on the main page. Is there a way to ensure that the legend's color remains consistent (for example, always blue) regardless of selection? 

 

Currently in the Format pane - Columns, I cannot change the color for "ALL" columns (it is grayed out).

 

Thanks!

 

1 ACCEPTED SOLUTION
v-fenling-msft
Community Support
Community Support

Hi, @hoosha_11 

I am glad to help you.

 

I'm not sure I understand what you mean correctly.
According to your description, you are using Clustered column chart visual, and you have dragged a field to Legend, so the visual shows a different colour, like this?

vfenlingmsft_0-1729733967744.png

 


But you want the colours of the column charts to be blue, even after drill through, like this?

vfenlingmsft_1-1729734028739.png

After drill through:

vfenlingmsft_2-1729734053151.png

 

 

If I understand correctly, you can try to use custom theme colours to achieve what you want:

vfenlingmsft_3-1729734171556.png

 

Then change the colours you need:

vfenlingmsft_4-1729734339053.png

 

 

I have attached the pbix file for this example below, hope it helps.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-fenling-msft
Community Support
Community Support

Hi, @hoosha_11 

I am glad to help you.

 

I'm not sure I understand what you mean correctly.
According to your description, you are using Clustered column chart visual, and you have dragged a field to Legend, so the visual shows a different colour, like this?

vfenlingmsft_0-1729733967744.png

 


But you want the colours of the column charts to be blue, even after drill through, like this?

vfenlingmsft_1-1729734028739.png

After drill through:

vfenlingmsft_2-1729734053151.png

 

 

If I understand correctly, you can try to use custom theme colours to achieve what you want:

vfenlingmsft_3-1729734171556.png

 

Then change the colours you need:

vfenlingmsft_4-1729734339053.png

 

 

I have attached the pbix file for this example below, hope it helps.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Great, Thanks! That worked!

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)