Dynamic tooltip pages in Microsoft Power BI for measure columns
We all know those nice tooltip pages in Power BI. They filter our data quite well.
But what if we do not have data columns in our table but rather measures?
If our table looks like this, the tooltip will not automatically figure out which measure we are using as a column. There is no SELECTEDMEASURE() or other function handed over. It will always show the measure we set in the tooltip when building it.
This will be misleading to users since they will e.g. always see the "profit" tooltip even when they hover over Sales or COGS (cost of goods sold).
There is a solution though, check out this video and see how you can make your tooltips fully dynamic.
The table on the left shows our standard tooltip and I have date columns and date rows
In order to solve this, I have created separate tooltip pages for every measure I am using in the table on the right (sales, COGS, profit and profit margin).
Then you just have to set the page in the visualization pane for the tooltip to Auto and Power BI will do the rest.
As you can see at the end of the video when I hover over the table on the right, our tooltip dynamically changes based on which measure (or column resp.) I am hovering over.