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:
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.
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:
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.
I think this is a great feature. The final chart resembled the following screenshot:
Talk to you soon,
P.S. Stay tuned for SQL Lunch updates.