topic Re: How to turn off cumulative total by day for a line chart. in Developer

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

PBI-Curious — Wed, 02 Jun 2021 19:28:44 GMT

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?

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

Fowmy — Wed, 02 Jun 2021 19:35:18 GMT

@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.

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

PBI-Curious — Wed, 02 Jun 2021 19:45:26 GMT

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?

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

Fowmy — Wed, 02 Jun 2021 19:52:13 GMT

@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?

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

PBI-Curious — Thu, 03 Jun 2021 13:16:48 GMT

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