Lets say I have 3 columns:
- Sales amount
- Product (A, B or C)
I move Sales to value, Date to Axe and Product to legend. I select a line chart I can now see the amount of each product sold per day with three lines referring to each of the products A, B and C.
How can I now add a total sales line to the (same) chart?
Go to Solution.
It is not allowed to add multiple lines together with legend to a line chart visual. As a workaround, I would suggest you choose Line and Clustered column chart.
Please Sales to column value, Date to Shared Axis and Product to column series. Then, create a measure to calculate total values and add it to line value.
I did this in the data. I created a query to pull the data and then UNION the same query but this time with Total as product
so select [Sales Amount], Product, date from table1
select [Sales Amount], 'Total' AS product, date from table1
Then total is one of my products with the total amount.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.