We have used a line chart which shows Total Finalised Plans of Stores over time.
When we select multiple stores it needs to show all stores with different colors(Legend), but when we select all stores It needs to shoe only single line: To solve this I had used following measure:
My problem here is that, when we show multiple stores, the legend shows their contribution as shown below:
But When selecting all lines and you hover over the stores should not show their own contribution but shows single value as below:
When we select All stores, it needs to show a single line and legend show their own contribution and not a single value as 81.
Solved! Go to Solution.
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications