Forum Discussion

hoosha_11's avatar
hoosha_11
Icon for Helper I rankHelper I
1 year ago
Solved

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!

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.