Oct 22 2021 11:35 AM - edited Oct 22 2021 03:27 PM
I want to build 3 charts and show them inside my SharePoint online modern page, the charts are as follow:-
1) First chart is to group the items from a single SharePoint list by Created date, and show the total number of items based on the day of the week (Mon till Sun).
2) Second chart is to show the total number of items from 4 different lists and show the percentage inside a pie chart
3) Third chart is to group the items from a single SharePoint list by Created date, and show the total number of items based on the month from the first month of the year till current month.
So how i can build such charts and show them inside modern SharePoint page? can i use the modern Quick charts web part, Power App or Power BI?
Thanks
Oct 24 2021 01:32 AM
Quick chart web part in SharePoint can only show the simple data without allowing any grouping/calculation (for data as well as labels).
So, you cannot achieve your above requirements using Quick chart web part.
Possible solutions:
Power BI:
SPFx web part:
See few SPFx samples developed by community members at:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Oct 25 2021 04:51 AM
@ganeshsanap so for using Power BI, will the users who will be viewing the Power BI reports need license as well? or the license is needed for users who develop/customize the reports?
Thanks
Oct 25 2021 06:56 AM
Other users also need Power BI Pro or Premium Per User (PPU) licenses.
Check this documentation: Share Power BI reports and dashboards with coworkers and others
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.