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.
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
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Did you miss the call? Check out the Power Apps Community Call here.
We are excited to announce the Power Apps Super Users!
Check out our new profile badges recognizing authored solutions!