Hello Excellers,
this is my first post ever in an Excel forum at the ripe old age of 56.
I just did an introduction post if you want to know who I am.
Anyway, some colleagues and I have developed what we think is a better way of building Excel Dashboards on Excel O365.
My colleagues have put out a post about it here:
www dot meta5 dot com/2020/04/26/meta5-enabling-the-excel-data-mart-dashboard/
On that post you can download a detailed white paper on how the dashboard is built and you can also download the dashboard itself.
My question here is this.
We are using the O365 internal data model and power query inside Excel to be able to support multiple slicers across all the charts and reports in the dashboard.
When the Excel workbook is opened up it now opens up quickly as we are not "pre-loading data on open".
But on first click of a slicer it appears that Excel is loading the data in to the power query model some how an then applying the click.
So we have the "first click is slow' problem.
I am guessing there is a way to fix this with some option for the workbook but I have no idea what that might be.
As I said, you can download the actual workbook (it's bigger than 1MB) from the link.
It is a public workbook with randomly generated data in it.
If you want to learn how the dashboards were created there is a detailed white paper.
My colleagues are planning on building LOTS of these dashboards so you might want to learn about what we are doing.
But this "first click is slow" problem has been something of a nuisance as we work out how to do dashboards in the best possible way in Excel.
Any comments would be most welcome!
Best Regards
Peter Andrew Nolan
Bookmarks