Forum Discussion
2 Cumulative Totals in Line Chart
Does anyone have any further thoughts on how to go about this please?
Hi DaveNic ,
According to your statement, you want to create a line chart that has cumulative (running) totals on both X and Y axis, the number of customer surveys that a company has had completed in X-axis against the number of those surveys that answered a question ('Would you recommend the company?)' positively in Y-axis.
Firstly, two cumulative (running) totals are calcualted by measures, however Power BI doesn't support us to add measures in Axis. Secondly, I think both measures are based on [Date]column, so at least there should be a [Year] or [Date] column in your visual. So I think this is not a good idea. I suggest you to compare two cumulative (running) totals individually by two linds or columns.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Thanks for your input. You are correct in your assumptions. I have both the running total of responses and of positive responses in measures at the moment and as such I'm unable to add them to both the x and y axis of the chart.
Plotting two lines against the date is the only option that I've seen that works in Power Bi so far, but in terms of being able to read and compare the overall performance on previous years, I dont think this is intutive. e.g as below (just one year plotted):
If the same data for previous years was also plotted it would get cluttered very quickly, and not really present the data in a way that could be readily understood.
What I'm trying to acheive is roughly as the below from Excel:
In other words, to be able to look at the charts and see at a glance whether performance is better or worse than it was at this point last year in terms of the numbers of surveys received.
Thanks,
Dave