Drill Through

Pivot tables in Excel and Power BI enable you to expand visuals to get to more details regarding your data.

However, both may not fulfill all your formating needs, which is why Excel is still used for static reports.

What happens if you are interested in the development of a line item, for example Sales? You would usually need to go to your supporting documentation to answer any ad-hoc questions - which usually takes time.

But if you set-up your data model correctly, you can adjust your report to get to the required analysis with a single click, directly from the report - mimicking the drill-down functionality of Power BI and Pivot Tables.

Check out the video for a short demonstration and feel free to reach out if you're interested on how to set this up.