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
- parry2k
Super User
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
