Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply

Copy Conditional formatting of one table to another

I have a table that has multiple rules.  I'd like to copy conditional formatting rules to another table.  Is this possible without having to manually define each value?

6 REPLIES 6
Anonymous
Not applicable

Yes it is possible.

- Go to transform data and create a conditional column (rename it if you want), then define any one condition.

- Click on the added conditional column that you created (look at the applied steps on the right side) and select all "Ctrl+A" and copy the whole query from the top which starts from =Table.AddColumn.

- Now, click on the new conditional column that you created in step 1 and replace the whole query using "ctrl+A" and then "ctrl+V"

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @KUNGFUPANDA559 

 

did you solve your problem?

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


mwegener
Most Valuable Professional
Most Valuable Professional

  1. Select the visual that already has the desired formatting options settings.
  2. Click the “Format Painter” button under the Home
  3. Click the visual which you’d like to assign the same formatting options.

https://community.powerbi.com/t5/Desktop/Conditional-formatting-copy-and-paste/td-p/664452

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Unfortunately @mwegener , Conditional formatting does not copy over using format painter

mwegener
Most Valuable Professional
Most Valuable Professional

Strange, during my small test it works.

Do you use the same columns as value?

Maybe it's easier to copy the table and change some columns.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Anonymous
Not applicable

You might find it quickest to simply copy and paste the table and replace the values you need changed

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.