Copy Conditional formatting of one table to another

[KUNGFUPANDA559]

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?

[Anonymous]

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]

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.

[mwegener]

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.

[KUNGFUPANDA559]

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

[mwegener]

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.

[Anonymous]

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