Forum Discussion

PBInonpro's avatar
PBInonpro
Icon for Helper III rankHelper III
4 years ago
Solved

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.

  • 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. ğŸ˜€

     

     

     

    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 ! 

     

     

     

4 Replies

  • 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. ğŸ˜€

     

     

     

    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 ! 

     

     

     

    • PBInonpro's avatar
      PBInonpro
      Icon for Helper III rankHelper III

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

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

    • PBInonpro's avatar
      PBInonpro
      Icon for Helper III rankHelper III

      Yep, I spent hours repeating the he process already.