Forum Discussion
Creating a line chart with a dynamic total line
Anonymous solution attached.
edhans , not sure if not having that function I'm missing anything. Never had a need for it but it can be surely handy.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS 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.⚡
Super UserAnonymous Is this what you are looking for, basically select the values in the slicer and always show the total of the selected points, as shown in the video below:
Not quite. Each selected value in the slicer should be it's own line. Total should also be an option in the slicer, and if that is selected, it takes the total of everything else selected and graphs that in addition to the other lines.
In my picture below, it should graph the count of Latin America and Taiwan over a date range. Total is the purple line and it is flat at 0, which is incorrect. For Jan 2021, the total should be at 31 (10 + 21).