Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
pborah
Solution Sage
Solution Sage

Can't change column legend to gradient for line and stacked column chart

I'm using a line and column chart where the column colors are on a gradient from dark to light grey. But I'm unable to change the legend settings to represent this. This makes the chart look really unprofessinal. Please help. Using latest version of PowerBI.

 

pborah_0-1700241516701.png

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @pborah 

Unfortunately, we don't have an option to customize the legend and it is generated according to category level only.

There is an idea about this please vote for it (i voted) 🙂

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=3ae917b5-4e34-47b7-bbf8-01eb9117ec7b
To get the graph with the correct legend you can use POWER POINT.

1. generate the legend and save it as a picture

Ritaf1983_0-1700282793167.png

2. import it to your report to the legend place 

Ritaf1983_1-1700282942002.png

3. Group it with the graph

Ritaf1983_2-1700282997363.png

Result:

Ritaf1983_3-1700283061201.png

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @pborah 

Unfortunately, we don't have an option to customize the legend and it is generated according to category level only.

There is an idea about this please vote for it (i voted) 🙂

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=3ae917b5-4e34-47b7-bbf8-01eb9117ec7b
To get the graph with the correct legend you can use POWER POINT.

1. generate the legend and save it as a picture

Ritaf1983_0-1700282793167.png

2. import it to your report to the legend place 

Ritaf1983_1-1700282942002.png

3. Group it with the graph

Ritaf1983_2-1700282997363.png

Result:

Ritaf1983_3-1700283061201.png

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thank you. I'm beginning to think this should qualify as a bug not a product feature update. Because not displaying the legend correctly as per chart settings is a type of error/mistake. Depending on who is using it, this could be a crucial bug.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.