The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
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"
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.
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
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.
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.
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
You might find it quickest to simply copy and paste the table and replace the values you need changed
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
80 | |
77 | |
45 | |
39 |
User | Count |
---|---|
149 | |
115 | |
67 | |
64 | |
58 |