Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Problem description
As described in the teaser above - working with too many page tooltips can result in very high number of pages in your report. In general this is something you want to avoid. Unfortunately, there is no direct function how to work with only a single tooltip page. Luckily, after introducing field parameters there is a way - let's take a look.
First, I will describe you my very simple report:
As you can see I have 6 different Card visuals. 3 on top (red section) and 3 on the bottom (blue section). Each visual contains a tooltip, which is a detailed distribution by countries.
Simple example for the revenue can be seen here:
To achieve this, I need to create a new page, mark it as a tooltip page and add related visualization:
So far so good, right? Problem is - that I need re-apply the same steps for other two card visuals. So I would end up with those pages:
Now you can imagine that my report is huge and instead of 3 different tooltips I need 30. Then it's not very conveniet jumping from one page to another. So what is the solution?
Solution description
1. We create field parameters with desired measures.
In my case I have only 3 measures:
I recommend you to uncheck the "add slicer to the page" since we won't need it.
2. We create a tooltip page (I call it T-all), the same way as before:
3. We add the desired visual, which will represent our tooltip. In my case it's column chart. But now the trick happens - instead of adding created measures on it's own, we will use our field parameters. This will bring all of our measures in the single visual.
(note: PBI can't handle huge number of measures in one visual, depends on which chart you use - you might find a different limits).
4. Once we are done with a tooltip page, we go back to our report and enable tooltip page on a visual:
5. Add field parameter as visual level filter.
This will enforce the tooltip to display only the desired measure and not the others:
Now let's check our result - as we see bellow our chart displays only Total Gross Profit.
If I apply the same logic for other cards I will achieve the same results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.