Published: 15 Oct 2019 | Author: James Honner
A great way to take your Power BI Reports to the next level is by using PowerBI Tooltips. Report Page ToolTips (RPT). RPT’s allow you to enhance your reports by giving your end users more information without taking up any real estate, cluttering the report canvas.
In the example below, we have a donut chart showing Revenue FYTD by Region. One great way to enhance visual this is to add a RPT showing the Top 5 Stores for each Region as your end users hover over the donut chart.
In the example below we’ve hovered over the ‘North America’ Region and the RPT shows us the Top 5 Stores by Revenue FYTD for that Region.
When we hover over the different Regions the RPT changes to show the Top 5 Stores for that Region.
As well as the RPT, we have setup a drill through on this donut chart and can still perform this action by right clicking and selecting the drillthrough option as shown below.
In our second example, we demonstrate that RPTs can also be used on bar charts. This bar chart shows Revenue FYTD by Country and when you hover over a Country the RPT shows the Revenue FYTD by month for that Country. These also change as you hover over the different Countries.
NB: This report also has dynamic measures and visual titles which we will cover in upcoming blogs.
In only a few steps you can create PowerBI Tooltips (RPT’s) in your reports, so let’s go through those steps now.
And you’re done! It’s as simple as that.
In upcoming blogs we’ll go through some more advanced concepts, dynamic measures/attributes as well as dynamic visual titles so stay tuned for that.
If you’d like to take your Power BI Reports and Dashboards to the next level and need help, please contact us to discuss how we can assist your organisation.
Get the latest Talos Newsletter delivered directly to your inbox
Automation & Analytics Technologies for Business
Build, test and implement Data Platform components - secure, efficient, flexible and cost effective.
Specialising in all customer-related processes, she has been trained to quickly learn specific customer processes.
Specialising in all compliance related processes, she has been trained to quickly learn specific compliance processes.
Specialising in all invoice-related processes, he has been trained to quickly learn specific invoice-related processes.