Skip to main content

Power BI

Needs Votes

color scale legend

Vote (202) Share
AndrewK's profile image

AndrewK on 29 Jul 2017 03:35:00

for scatter plots, conditional formatting, and line plots, enable data viz to have a legend that is a color scale gradient

for example,
1) in scatter plot using saturation, we should have a legend that indicates what the darker and lighter colors represent
2) same goes for conditional formatting in tables and matrices
3) line charts without a field in the "legend" bucket (i.e. line charts represented by a single line) should be eligible for a line graph that has its color change according to a gradient as the value increases or decreases (e.g. a line graph that plots a growth rate could have green as positive growth and red as negative growth)

What's key here is that the legend shows the gradient, which means the max, min, and perhaps a few other points (e.g. middle) would be called out with their numeric value in the legend.

Comments (15)
AndrewK's profile image Profile Picture

f3e4ab79 ec0e-442d-94d4-8541191e1ca5 on 16 Aug 2020 04:06:05

RE: color scale legend

The gradient scale for the color legend will also help remove/decrease the limitation of the number of categories plotted on a line chart for example. I have a need to view all lines (within the line chart) of the selected data to surface the most common trend/s.

AndrewK's profile image Profile Picture

14efbccf dacc-41ab-91da-69c77f661b80 on 16 Aug 2020 04:03:59

RE: color scale legend

It is a must for shape maps

AndrewK's profile image Profile Picture

df5f464f c516-4d0a-a65e-2d525e092c15 on 16 Aug 2020 04:03:19

RE: color scale legend

Definetely agree for a scale legend for shape maps. it would be essential !

AndrewK's profile image Profile Picture

3d3e7b27 cb85-42e8-bc8e-098ae0d33d06 on 16 Aug 2020 04:02:19

RE: color scale legend

'+1. I'm using shape maps. A color scale legend is essential for presentation.

AndrewK's profile image Profile Picture

b10f08b8 93a6-49c3-8581-05c3a471a6e9 on 16 Aug 2020 04:02:15

RE: color scale legend

A great example of this, using date as the colour gradient, can be seen here: https://www.accountingweb.co.uk/tech/tech-pulse/coding-for-accountants-training-a-machine-learning-algorithm