Forum Discussion
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
- mwegener
Most Valuable Professional
- Select the visual that already has the desired formatting options settings.
- Click the “Format Painter” button under the Home
- 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.
Unfortunately mwegener , Conditional formatting does not copy over using format painter
- mwegener
Hi Anonymous
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.
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"
