Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need to create an accumulative graph, in other words, I need to divide the "Finished" by the total and order the graph by month and add a "Year" filter at the top.
StatusYearMonth
Finish | 2016 | January |
Cancelled | 2013 | Febraury |
Opened | 2014 | March |
Paused | 2015 | December |
Finish | 2016 | February |
Cancelled | 2013 | Febraury |
Opened | 2014 | September |
Paused | 2015 | June |
Finish | 2016 | March |
Cancelled | 2013 | Febraury |
Opened | 2014 | March |
Paused | 2015 | December |
Finish | 2014 | April |
Cancelled | 2014 | Febraury |
Opened | 2014 | September |
Paused | 2014 | June |
Finish | 2016 | May |
Cancelled | 2013 | Febraury |
Opened | 2014 | March |
Paused | 2015 | December |
Finish | 2014 | June |
This must be applied for about 100,000 or more; the table has about 100,000.
I hope you can help me.
Cheers!.
Hi, @Anonymous
It's not very clear, you can show the results you want in the form of pictures.
It will better help us understand your requirement.
Best Regards,
Community Support Team _ Eason
Hello @Anonymous
If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.
You can send the sample .pbix file by adding it to your drive or dropbox and add the link here.
Regards
Kumail Raza
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |