Forum Discussion
Run Chart Legend like Excel
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.
2 Replies
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.⚡
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
