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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Kealkil4
Frequent Visitor

Format Painter

What does the Format Icon in Power BI Desktop actually achieve ... and how do you go about doing it?

 

It is highlighted when in Report View.

 

Thanks

 

1 ACCEPTED SOLUTION
Phil_Seamark
Microsoft Employee
Microsoft Employee


Select the visual that already has the desired formatting options set.
Click the “Format Painter” button in the Home tab of the ribbon.
Click the visual for which you’d like to assign the same formatting options.
The following Formatting Options are copied when using the Format Painter:

- All Background options.

- Title: All options apart from the actual text.

- Data Labels: All options except Display Units & Decimal Places.

- Data Colors: Default Color and, if the same field is used to drive color, copy the color/value assignments.

- X-Axis & Y-Axis: All options apart from Start/End.

- Legend: All options apart from the actual text.

- Borders: All options.

- Slicers: All options.

- Sentiment Colors (for Waterfall Charts): All options.

- If options don't exist in the target visual (e.g. copying X-Axis options from a Scatter Chart onto a Column Chart) then they are just dropped.

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Phil_Seamark
Microsoft Employee
Microsoft Employee


Select the visual that already has the desired formatting options set.
Click the “Format Painter” button in the Home tab of the ribbon.
Click the visual for which you’d like to assign the same formatting options.
The following Formatting Options are copied when using the Format Painter:

- All Background options.

- Title: All options apart from the actual text.

- Data Labels: All options except Display Units & Decimal Places.

- Data Colors: Default Color and, if the same field is used to drive color, copy the color/value assignments.

- X-Axis & Y-Axis: All options apart from Start/End.

- Legend: All options apart from the actual text.

- Borders: All options.

- Slicers: All options.

- Sentiment Colors (for Waterfall Charts): All options.

- If options don't exist in the target visual (e.g. copying X-Axis options from a Scatter Chart onto a Column Chart) then they are just dropped.

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Voila!

 

Thank you Philip.   I had been trying to use it to copy the Formatting that is part of the Measure Definition!

 

I can see where it still comes up short ... but it does save a lot of work when trying to make Reports all have similar formatting.

 

I meant to say thank you much earlier!

 

Best Regards,

 

Ted.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors