I have a drill through in my crime reports so you can drill through to the data from the top level report. However, sometimes I am aware that users struggle with these cool Power BI Features.
A new feature is that if you have a drill through, you get a Right click to drill through message on the tooltip. Is that enough? for some people its not. Some people don’t understand the concept of drill through. They may need more visual help.
And its all about making sure the users are getting the full benefit of Power BI so its worth adding a few extras
How about creating a short video of the drill through in action that you can add to the visual.
To create a video of the drill through I am going to use ezvid as its free for this demo. Camtasia is the solution I want to move to because this will save the file as an animated jpg.
I have downloaded from the following site
And in order to record a small part of my screen I have had to set my monitor to display at 100%
Ezvid creates a final.wmv file
Convert wmv to jpeg
the video needs to be a jpeg in order to work so I need to convert the file I have created
For the purposes of this example I have used convertio
an online tool for conversion.
and I have simply converted and downloaded the file to a gif.
Back to Power BI
In the report, add a new page. I am calling in Drillthrough tooltip
Right click on the worksheet and hide the page
next in page format, go to page information and Set Tooltip as ON
Go to page size and set type as tooltip
Next in Page format go to page background and add image (I am adding the video that I created. make sure you have the location of the jpg to hand
Make sure that transparency is at 0% and the Image fit is Fit.
You should be able to see your gif moving in your tooltip page which is ready to be used in the top level report
Go back to the visual that will be using the drill through animation
In format for the visual go to Visual Header and scroll right down to Visual header tooltip icon
Tip. People are missing this is the list, note that there are two scroll bars and ensure you have scrolled down to the bottom with the inner scroll bar.
A little Question mark appears at the top of the visual
We now have a new option in the format list. Visual Header Tooltip, where you can add written instructions on your visual
but we want to do something fancier and have the video clip playing
Change the Report page from none to the tooltip page and now when you hover oper the question mark a how to video will play.
This is a great way of showing off some of the more involved concepts of how to use Power BI.