When you create a report it’s highly likely that you’d like to copy other visuals’ formats from an already formatted visual using “Format Painter” tool in Power BI. Perhaps you already used this awesome tool available in Power BI Desktop.
As you see in the tooltip shown while hovering over the “Format Painter” tool you can simply copy formats from an already formatted visual to another visual. But what if you have a lot of similar visuals to be formatted (painted) like shown in the below screenshot that I have several card visuals on top of my page. One of them is formatted as desired but the rest must still be formatted.
It would be good if I could paint all of them in one go right? So continue reading to see how we can do that.
Here is the trick:
- Group all card visuals other than the one you’d like to pick the format from
- Click the “Format Painter” tool to pick the visual format using the “Format Painter” tool
- Paint the group (not each visual though)
Did you know about this trick? Have you used this before? Is there any ways you’d like to share with others? Let us know in the comments section below.