The ability to look at summarise data into a meaningful image on a screen but then to use that to drill through for more detail when required is incredibly useful and very powerful.

This example shows a Gantt chart summarising the Olympic Events happening in Japan based on UK times.  The data is summarised on one page to give an indication of the spread of events over time.

The report is set up to enable you to hover over each are and get a summary of the events using the Tooltip feature.  This is great for a smaller number of events, but when you want more detail you are unable to scroll down using the tooltip.  In a recent PowerBI update the drill through capabilities were improved to make it easier for the user to access more detailed information.

The tooltip is not only used to summarise key information but to remind the user that they can drill through using the right click button on the mouse.

Have a look at the embedded report to see how the report works.  The aim is to make it as easy as possible for the user to navigate through the report.

Most of the reports I work on are commercially sensitive, however, I find this initiative by a group of amazing data evangelists really help develop the visual aspects of Power BI but also give a chance to showcase what Power BI can do.

Keeping current and up-to-date is essential in this industry, and this is an excellent way to do this visually

Any questions, happy to help, 

Sue 

LinkedIn
Twitter
Facebook