Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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?
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 |
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
2 | |
2 | |
2 |