Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

PowerView: Coordinating Chart Colors

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.

Comments

Leave a comment on the original post [www.bidn.com, opens in a new window]

Loading comments...