Forum Discussion
Applying a formatting rule to multiple charts
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!
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
4 Replies
- dharmendars007
Memorable Member
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
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!
v-achippaCommunity Support
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:
- Initially select your stacked column chart visual which you want to give same colors to other chart visuals
- Now from the Home ribbon select Format painter (It will take the colors from that visual)
- 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
That was quite well explained, thank you for the details.
