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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
pborah
Impactful Individual
Impactful Individual

Is it possible to have legends for reference, trend and forecast lines in line chart?

Pretty much what the question asks. I have a line chart showing the movement of a measure monthly over the last few years. In there I have a trend line, two reference lines (average and max), a forecast and shaded forecast confidence region. All colour separated. Is it possible to have legends for all of them? Thanks.

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @pborah 
You can create the legends manually with textboxes/tables.

Examples :

Ritaf1983_0-1718245366783.png

Ritaf1983_1-1718245476898.png

The pbixes with examples are 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 
You can create the legends manually with textboxes/tables.

Examples :

Ritaf1983_0-1718245366783.png

Ritaf1983_1-1718245476898.png

The pbixes with examples are 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
pborah
Impactful Individual
Impactful Individual

@Ritaf1983 thank you. That is one option but not the cleanest one. I will have to consult with report stakeholders if they like that or not.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.