Run Chart Legend like Excel

[tmitton]

I have a run chart visual in one of my reports and I've used the "Analytics" feature to generate a trend line, a median line, and a target line. 

In Excel you can easily add a legend that indicates what each line is for (see the legend in the bar chart visual), but I can't figure out how to do this in Power BI. I've added screenshots of both Excel and Power BI visuals. 

[Anonymous]

HI @tmitton,

Nope, current power bi visual does not support this.
Perhaps you can manually create a table with all legend types and use it on your visual legend fields, then write a measure with the switch to redirect different values based on the current legend.

DAX – Making the “Case” for SWITCH() - P3 Adaptive

Regards,

Xiaoxin Sheng

[parry2k]

@tmitton Not sure if you can do this in Power BI. Maybe you can create your own measures for these lines and then use it in the visual.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡