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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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"

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


  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

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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