Cumulative percentage is showing more than 100 in report.

[Anonymous]

Hi All,

I have crfeated a Line chart where cumulative percentage is calculated on basis of dates.If I select all dates then percentage gets sum up for all dates and showing in 1000.Please help me to resolve this.

Regards,

Nithin

[Greg_Deckler]

Can you at least post the formula for your calculation and/or example data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490... example data?

[Anonymous]

Hi ,

Please find the below report where percentage in Y axis showing in millions If we select multiple dates from create_date slicer.

sample data is also pasted below:

Here cumulative percentage is calculated in table by create_date basis and Im pulling directly that column into report.If I select multiple dates then  cumulative percentage of each date is get sum up and is displaying in report.

Create_date	id	in_wave_percentage(cumulative)
12-Dec	o	25
12-Dec	1	30
12-Dec	2	45
12-Dec	3	55
12-Dec	4	75
12-Dec	5	95
Create_date	id	in_wave_percentage(cumulative)
13/12/2019	o	15
13/12/2019	1	20
13/12/2019	2	45
13/12/2019	3	65
13/12/2019	4	75
13/12/2019	5	85
Create_date	id	in_wave_percentage(cumulative)
14/12/2019	o	5
14/12/2019	1	10
14/12/2019	2	45
14/12/2019	3	65
14/12/2019	4	77
14/12/2019	5	100