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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Employee
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
Employee
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors