Been trying to sort this query out on my own via the normal routes but facing issues.
What i have already is a App thats collecting data and saving it to a large SharePoint list, which is working fine.
Now i am trying to create like a mini dash board that i can use to get data back from items save on the SP List in a form of a graph or table.
How i am trying to get it to work is by having two dropdowns (Date and Zone) then once i have selected these items then for the graph/table to populate.
Below is a pivot chart i created in excel using the same type of data to show what i am trying to create, but wouldn't require the pivot table. (hope that makes sense?)
Any advise or help would be appreciated as always.
Follow this post i just replied successfully today:
I have manged to produce a graph showing zones and costs against them, but its showing multiple zones.
Think this is due to costs being entered on different dates.
What i want to know is it possible for the two drop downs to control the graph so if a certain date and zone are selected then the graph would show the information based on those two drop downs?
Ive added a screen shot below to show what i am currently getting
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021