The part in red is what I'm having trouble with, the rest is just background information.
Lets say we have:
- Nine Power BI reports, each handling a different key performance indicator (sales, safety, attendance, expenses, vendor compliance, store traffic, etc.)
- Those nine reports have mutliple pages of measures and visuals specific to their performance area
- Those nine reports are too big to combine into one report as we get out of memory error.
- One visual for each kpi that indicates above goal or below goal for the current week.
- We have 100 stores and thus, 100 store managers
I want to create a KPI dashboard using nine tiles such that:
- Each of the 9 tiles are added to the report and change when the data is updated.
- Each manager just logs into the App Dashboard once at the start of the day to check performance for the week.
- Each manager needs to only filter to their store on the dashboard page or is setup with view to their store by default, but they don't need to filter each tile.
- The manager can see at a glance all nine KPIs and easily see in red or green.
- They will then dive into the report for futher analysis like one normally would with a dashboard.
I've spent over a dozen hours searching Google, Bing, forums, and ideas trying to figure out how to do this and I can't figure out how to do it, but I can't believe it isn't possible. I'm at a loss and throwing myself at the mercy of this community. Has anyone done this? Or, am I going to be forced to look at the Report Server paired with SQL? or some other alternative you'd recommend? We'd prefer not to involve our IT dept. so that changes can be quickly made by our BI team.
