Dynamic tooltip pages in Microsoft Power BI for measures as 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 or matrix 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 and filter 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 data columns as my columns and data columns as my rows.
In order to solve this, I have created separate tooltip pages for every measure I am using in the table on the right (KPI by product - 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 measure/KPI dynamically changes based on which column/measure I am hovering over.