How to turn off cumulative total by day for a line chart.

[PBI-Curious]

PBI Community Good Day!

Per the screen shots below, I have successfully created a line chart by volume by day. Is there a way to turn off the cumulative total for the volume by day and replace it with the actual volume by day?

[PBI-Curious · Accepted solution]

Hello Fowmy

After creating my demo PBIX to send to you, I couldn't recreate the issue I was having in my production model.  As a result, I discover the issue to my problem. Now I'm getting the results expected in the visual. What I have learned per our interaction is by recreating the outcome you are trying to achieve you find the solution to your problem.

Much appreciate your quick turnaround to help!

Thank you

[PBI-Curious]

Hello Fowny

I believe you want to subtract the previous row value from the current row value.

That is correct.....

What you are showing is the Table visual, can share a sample of the data table?

Volume for an activity by day....If need be, how can I send you a sample data set?

[Fowmy]

@PBI-Curious 

You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?

[Fowmy]

@PBI-Curious 

What you are showing is the Table visual, can share a sample of the data table?

I believe you want to subtract the previous row value from the current row value.