Forum Discussion
Line chart with total as a Legend
Hi, Is it possible to show a total of sales as a legend in line chart? I have got a dataset that contains Product(A,B,C), Date(2006,2007,2008) and Quantity(10,20,30) columns , Currenlty I'm g...
I was looking for an answer to this and didn't find it - I did solve my own issue so I thought I'd share the answer here.
I have traffic/transport data so what I want to do is: see the volumes by direction but also the total volume as a line. E.g. southbound, northbound and total.
What I did: I created two quick measures, under calculation selected "filtered value", my base value is the traffic volume and the filter is a direction (so one measure is for south and one for north). Then add the two new quick measures as values in the chart as well as the unfiltered - and DONE 🙂