Forum Discussion
Solved
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
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.
2 Replies
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.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.
