Showing results for 
Search instead for 
Did you mean: 
Resolver III
Resolver III

Interesting feature of Format Painter

I have a column chart and line chart with markers (shapes), both of which used the same measure but with different axes. Modifications to the column chart included conditional formatting for negative and positive values (red and green). Using the Format Painter, I copied the formatting of the column chart to the line chart. Although the line chart does not have the option for conditional formatting, the Shapes of the line chart now show in red/green based on their negative or positive values! 


I later found this blog posting about using the Legend field for line coloring, but the above marker coloring gives a nice effect when you have both positive and negative values in the chart.


Community Support
Community Support

Hi @RandyPgh ,



Thanks for your sharing!



Best Regards,


Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors