Alternative to Pivot Table in Dashboard for better UI Experience
02:11 05 May 2026

currently I am using Excel to build a dashboard for asset management, in particular it is used to track how many items remain after someone borrow it for a particular date range. The data comes from MS Form and has been populated into Excel. I have cleaned up and transform the original data using Power Query and the final form of my data to build the dashboard look something like this.

image showing data that has been processed using Power Query

I wish the dashboard to be able to show the following part bracket in red, which represent the details of items being borrowed.

Image in red rectangle showing the current approach using pivot table

Currently I am using pivot table as my solution, as you can observe above. Is there any idea or solution to enhance the overall look of the dashboard? Basically, what I want is instead of directly on the Excel grid, can this be turned into draggable table pane?

excel pivot-table dashboard microsoft365