http://www.sqlservercentral.com/blogs/sqldownsouth/2012/01/10/powerview-coordinating-chart-colors/

Printed 2014/04/18 07:46AM

PowerView: Coordinating Chart Colors

2012/01/10

During a recent customer engagement I was asked if it was possible to ensure that the colors in a Line Graph for a particular value would be the same color for the same value on a Bar Chart.  I thought, GOOD QUESTION.  I launched PowerView and started creating a report.  First I created the following chart:

image

Notice the color of each line, blue for maximum, red for average and orange for minimum.  I created a bar chart using the same values, but using a different axis value.  Notice that the colors don’t match. 

image

Instead I have blue for average, red for minimum and orange for maximum.  What to do?  Well it’s pretty simple.  to the left of the report, locate the Values box.  Initially this is what it looked liked for the bar chart:

image

To correct the problem, change the order of the values to match the order used for the line graph.  Once that is done your colors should be the same for each value across the two charts.

image

I think this is a great feature.  The final chart resembled the following screenshot:

image

Talk to you soon,

Patrick LeBlanc

P.S.  Stay tuned for SQL Lunch updates.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.