Forum Discussion
Applying a formatting rule to multiple charts
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
Memorable MemberHello 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!