Applying a formatting rule to multiple charts

[ctiago]

Hi,

I have multiple (stacked) column charts. Under Columns-->Color I create a rule to have slightly different column colors based on the  value of an X-axis variable.

My question is simply whether I can reapply the same rules (such as this) to multiple charts or if I must manually do it for each of them.

Grouping visuals does't seem to allow it as it offers far less formatting options once the grouping is done.

Thank you!

[v-achippa]

Hi @ctiago 

Thank you for reaching out to Microsoft Fabric Community.

In Power BI does not natively support applying the same conditional formatting rules across multiple visuals. Each visual requires the rules to be manually recreated, as there is no built-in option to save or copy-paste these formatting rules.

But we can achieve it by following the below approach:

1. Initially select your stacked column chart visual which you want to give same colors to other chart visuals
2. Now from the Home ribbon select Format painter (It will take the colors from that visual)
3. With that paint brush select the visual which you want to replicate the same colors
   Follow below screen shot, similarly you can do this for multiple visuals

Before:

After:

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thank and Regards,

Anjan Kumar Chippa

[ctiago]

That was quite well explained, thank you for the details.

[dharmendars007 · Accepted solution]

Hello @ctiago , 

In Power BI, there isn’t a direct method to apply the same conditional formatting or rules across multiple visuals automatically. However, here are some approaches that can make this process more efficient.

1. Format Painter - Use the Format Painter to quickly copy visual formatting from one chart to another.

Go to the Format tab >> Click on Format Painter >> Select the target visual to apply the copied formatting.

This works for most formatting, but it does not always replicate data-specific conditional rules.

2. Create a DAX measure for color logic, like

ColumnColor =
SWITCH(TRUE(),
[X-Axis Value] = "Condition1", "#FF0000",
[X-Axis Value] = "Condition2", "#00FF00",
"#CCCCCC" // Default)

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[ctiago]

On a small note, in Power BI Desktop I found the "format painter" in the "Home" tab, other than that, that does help and I appreciate the options!