You built perfect conditional formatting on one matrix. Now you have nine more visuals that need the same logic, and Power BI doesn’t have a “copy formatting” button. Recreating color scales by hand is tedious and guaranteed to drift out of sync. Here are the three approaches that actually work — ranked by how much maintenance they save you.
Why there’s no copy button
Conditional formatting in Power BI is stored per visual, attached to the specific measure or column it targets. There’s no clipboard for “take these exact rules and apply them elsewhere.” That limitation is the whole reason this question shows up so often in the Power BI community forums. The workaround isn’t a button — it’s designing your formatting so it’s reusable from the start.
Method 1: Reuse a color measure (best for logic-based formatting)
If your formatting comes from a measure using Field value (the pattern in our conditional formatting guide), copying is trivial: point every visual at the same measure.
// One measure, used by every visual that needs this color logic
CF Sales vs Target =
VAR Pct = DIVIDE([Total Sales], [Sales Target], 0)
RETURN
SWITCH(
TRUE(),
Pct > 1.05, "#22C55E",
Pct >= 0.95, "#F59E0B",
"#EF4444"
)
To “copy” the formatting to a new visual:
- Add the visual.
- Open the measure dropdown → Conditional formatting → Background color.
- Set Format by to Field value.
- Select
CF Sales vs Target.
That’s it. The new visual inherits the exact same logic, and when you change the thresholds, every visual updates at once. This is the only method where “copy” means “do nothing twice.”
Gotcha: the measure has to make sense at the new visual’s granularity. A color measure built for a region-level matrix will paint a product-level table incorrectly if the ratio calculation changes meaning at that grain. Test on a sample cell before trusting it.
Method 2: JSON theme for report-wide color rules
When you want consistent formatting across an entire report — not just one measure — a custom JSON theme is the real answer. Themes carry color definitions and, with a bit of structure, conditional formatting rules that apply wherever the theme’s rules match.
Export the current theme: View → Themes → Customize → JSON theme file. You get a json file describing your palette. The part you care about for conditional formatting is the "visualStyles" block, where you can pin default formatting per visual type.
A simpler, lower-risk use: define your brand colors once in the theme, then reference those same hex values in every color measure (Method 1). That way your red is always #EF4444, not three slightly different reds across the report.
To apply an updated theme, go to View → Themes → Browse for themes and select the file. Every visual using theme colors updates instantly.
When to use this: you’re standardizing a corporate report (think Contoso’s monthly finance pack) where color meaning must be identical everywhere. It’s overkill for a one-off matrix.
Method 3: Manual copy via visual duplication
For a quick one-to-one copy between two similar visuals, duplication beats rebuilding:
- Select the formatted visual.
- Ctrl+C / Ctrl+V (or right-click → copy) to duplicate it.
- Swap the field or measure in the new copy. The conditional formatting rules carry over with the visual.
This works because the duplicate is a literal copy — rules included. Then you only adjust the field, not the formatting. It’s fast for “I want this same table but for a different region,” and useless for “I want this formatting on a completely different visual type.”
Copying between reports
Cross-report reuse needs a theme file (Method 2) or a measure in a shared dataset. If your color measures live in a shared Power BI dataset that multiple reports connect to, every report can use the same CF Sales vs Target measure without redefining it. That’s the enterprise-grade answer — define once, consume everywhere.
For a standalone report, save your JSON theme and import it into the new report. The colors transfer; the measure-based rules transfer only if the measure exists in that model too.
Common mistakes
Mistake 1: Rebuilding rules by hand in every visual. You get five matrices with five slightly different thresholds. Use a color measure instead.
Mistake 2: Expecting “Format painter” to copy conditional formatting. Power BI’s format painter copies visual styling (fonts, borders) but not conditional formatting rules. Don’t waste time hunting for it.
Mistake 3: Editing the threshold in one visual and forgetting the others. If you hand-built rules, this drift is guaranteed. Method 1 eliminates it.
FAQ
Is there really no copy-paste for conditional formatting? Not between unrelated visuals. Duplication copies it within a report; measures and themes are the only ways to share it broadly.
Can I export just the formatting rules? No standalone export. Your closest option is a JSON theme (carries visual defaults) plus keeping your color logic in measures.
Does copying via duplication break if I later change the source measure? Yes. Duplicated visuals keep their own rule settings; they don’t link back to the original. Only measure-based formatting stays in sync automatically.
What about paginated reports? Paginated (SSRS-style) reports handle color through expressions, which are inherently reusable across textboxes. Different tool, same principle: define the logic once.
What’s next
- Conditional Formatting in Power BI: A Complete Guide — the measure and rule patterns this article builds on.
- Conditional Formatting for Charts, Bar Charts & Gauges — applying the same reuse principles to visual elements.
- Power BI Dashboard Design Principles — keep color consistent across the whole report, not just formatted cells.