line chart - color gradient

[vijaybansal3000]

I am trying to look at variation of ridership values with month. I have plotted data for 10 years but all the lines appear in different colors which makes it little difficult to understand unless you have legend opened on the side

Is there any way by which I can change the color of my years based on a gradient. For example all the lines are shades of green; 2006 being dark shade of green, 2000 being lighter shade of green and 1996 being the lightest.

[Anonymous]

Hi @vijaybansal3000,

You could select the paint roller icon and expand "Data colors" and manually assign different gradients of 1 or more colors. It's not the ideal way, but it will accomplish what you want.

[vijaybansal3000]

Thanks @Anonymous.  I am looking for some way like below which can be acheived in Tableau. 

[Anonymous · Accepted solution]

You could do it in R, though you lose interactivity back into your dataset etc.  Something like:

library(ggplot2)    # Needed for ggplot
# Avoid having to reference dataset$ each time in function calls
attach(dataset)

#Plot the Count dataset by Month and Year, with Year to set the fill colour
ggplot(dataset, aes(x=Month, y=Count, group=Year, colour=Year)) +
#Use lines on the plot
  geom_line() +
Restrict the colur hue to (around) the green range
  scale_color_hue(h=c(90,180))

 You may need to fiddle with the scale_colour_hue parameters to get exactly what you want.

[vijaybansal3000]

Thanks @Anonymous. This seems to be a good way. Though I would have loved this as a feature inbuilt in PowerBI itself without going to R code.

[Anonymous]

Hi @vijaybansal3000,

Currently, it is impossible to change the color of years based on a gradient in Power BI Desktop, an idea about this issue has been submitted in the following link, please vote for it. In your scenario, you can set discrete set of colors using Format option as mihart’s post.  Or set color using R code following Steve’s suggestion.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15906193-continuous-color-palette...


Thanks,
Lydia Zhang