cancel
Showing results for 
Search instead for 
Did you mean: 
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
Microsoft


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
Microsoft


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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.