Looking to create a pie chart with a dropdown menu that users can see different data in the pie chart based on the dropdown menu selections which include by "current year" and "current month" of the column called "Status". The column is a "Choice" SharePoint column. In addition to the SharePoint column I need to see the total count of each value.
Waiting Approval 5
Not Accepted 3
Thanks in advance.
Solved! Go to Solution.
Make sure you are using Value for your Labels in the PieChart definition and Legend for the Legend.
If the formula I provided you hasn't changed, then there is no way the Value would have a count in it. Only the Legend column gets a count in it.
Oh yes...I've seen lots of quirks with the charts. Many times I have to select the entire items property and delete and then paste back in...then everything is fine. This same condition happens on dropdowns and comboboxes too.
I've got quite massive questions, 4 functionalities I require to display dynamically on my dashboard screen are
1. Pie chart: I need to make a pie chart display according to the selected dropdown choice of user
2. Legend: legend shows hardware category according to pie chart results
3. Gallery: device categories displays on gallery Title reflecting from pie chart results
4. Gallery: Subtitle displays number of hardware, from the pie chart results
I've been following this thread and tried the above syntax on the datacard in the canvas but still have no luck.
This is what the current screen looks like
Syntax for Item property of gallery is
"AddColumns(GroupBy(hardware,"category","Group"),"CountDevice",CountIf(hardware, status <> "Discard"))
For Title of the gallery is "ThisItem.category"
For Subtitle of the gallery is "CountIf(hardware,category = HWCategoryTitle.Text && status <> "Discard")"
Syntax for Update Property of hwPieDatacard on the canvas
Thank you in advance,
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.