- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
But you want the colours of the column charts to be blue, even after drill through, like this?
After drill through:
If I understand correctly, you can try to use custom theme colours to achieve what you want:
Then change the colours you need:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
But you want the colours of the column charts to be blue, even after drill through, like this?
After drill through:
If I understand correctly, you can try to use custom theme colours to achieve what you want:
Then change the colours you need:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great, Thanks! That worked!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-23-2024 07:43 PM | |||
12-10-2024 12:28 AM | |||
12-19-2024 07:55 AM | |||
01-19-2025 07:15 AM | |||
07-08-2023 09:15 PM |
User | Count |
---|---|
83 | |
80 | |
47 | |
37 | |
37 |