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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
PBInonpro
Helper III
Helper III

Visualization Formatting: save function?

Is there any option to save the formatting of a visualization to apply to another? (aside from copy/paste)? 

 

And bonus question; is there anyway to save a query to be applied to antother? Whenever I move a document or rename a folder I go into the 'source' but then I have to recreate the steps in the query.

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

Try this to clone visual formating .... 

 

create any 2 visuals  (eg 2 cards or a card and a slicer or table and matrix).

 

Dispay different measures in visual1 and visual2

 

Format the font, background, borders, etc on visual 1

 

Click on Visual 1 and then click on Format painter 

and then click on visual 2

 

Voila !  You have copied the formats but not changes the measures. 😀

 

speedramps_0-1662810068797.png

 

 

How to copy queries

 

Open PBIX 1 which has the queries you want to copy from.

Open PBIX 2 where you want to copy queries to.

 

Select one of more query from PBIX1 .... you can select multiple queries with the ctrl or shift key.

Press copy to attahed them to the clip board.

Then paste them in PBIX2

 

Voila !  You have copied the queries from PBIX1 to PBIX2

 

 

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remember we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button. 

If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime.  I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

 

 

 

View solution in original post

4 REPLIES 4
speedramps
Super User
Super User

Thank you.  This button save hours of work and helps conforms your visuals to one standard format, which looks neat for the users.

Yep, I spent hours repeating the he process already. 

speedramps
Super User
Super User

Try this to clone visual formating .... 

 

create any 2 visuals  (eg 2 cards or a card and a slicer or table and matrix).

 

Dispay different measures in visual1 and visual2

 

Format the font, background, borders, etc on visual 1

 

Click on Visual 1 and then click on Format painter 

and then click on visual 2

 

Voila !  You have copied the formats but not changes the measures. 😀

 

speedramps_0-1662810068797.png

 

 

How to copy queries

 

Open PBIX 1 which has the queries you want to copy from.

Open PBIX 2 where you want to copy queries to.

 

Select one of more query from PBIX1 .... you can select multiple queries with the ctrl or shift key.

Press copy to attahed them to the clip board.

Then paste them in PBIX2

 

Voila !  You have copied the queries from PBIX1 to PBIX2

 

 

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remember we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button. 

If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime.  I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

 

 

 

Accepted and thumbs up! thank you kind person! this is the solution I was looking for!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.