Forum Discussion
Tooltip per column in a matrix
Hi,
I'm working with a matrix. It has two colmus as rows were his tables are conected by a link table and in values, it has a column in a table not conected to this two.
This table (Energie columns) has a relationship with another by his ID (Energie descriptions). The relation is many to one.
I'm trying to have a tooltip that shows me the description depending on the column for the matrix.
Is this posible?
Hello Davidmllu
Short answer: yes, but only on the value cells, not on the column headers - Power BI doesn't support tooltips on matrix column headers. And this only works if your columns come from a field (pivoted values), not from different measures. If each column is a separate measure, the tooltip cannot change per column.
Since your Energie table isn't directly related to the row tables, the matrix tooltip has no automatic way to know which column's context to use. You need a measure that captures the current column's ID and looks up the description:
Selected Description = VAR CurrentEnergieID = SELECTEDVALUE('Energie'[EnergieID]) RETURN LOOKUPVALUE( 'Energie Descriptions'[Description], 'Energie Descriptions'[EnergieID], CurrentEnergieID )LOOKUPVALUE is the right tool here because it doesn't depend on relationship direction or filter propagation — which matters since Energie is unrelated to your row tables.
Either:
- Quick way: drop the measure into the matrix's Tooltips bucket.
- Nicer way: build a Report Page Tooltip - create a new page, set Page information → Tooltip = On and Page size = Tooltip, add a Card bound to the measure, then in the matrix's Format → Tooltip select that page.
Hovering a value cell will now show the description for that column. Totals/subtotals will show blank, which is expected.
Cheers,
Metrica Team
6 Replies
- metrica
Post Prodigy
Hello Davidmllu
Short answer: yes, but only on the value cells, not on the column headers - Power BI doesn't support tooltips on matrix column headers. And this only works if your columns come from a field (pivoted values), not from different measures. If each column is a separate measure, the tooltip cannot change per column.
Since your Energie table isn't directly related to the row tables, the matrix tooltip has no automatic way to know which column's context to use. You need a measure that captures the current column's ID and looks up the description:
Selected Description = VAR CurrentEnergieID = SELECTEDVALUE('Energie'[EnergieID]) RETURN LOOKUPVALUE( 'Energie Descriptions'[Description], 'Energie Descriptions'[EnergieID], CurrentEnergieID )LOOKUPVALUE is the right tool here because it doesn't depend on relationship direction or filter propagation — which matters since Energie is unrelated to your row tables.
Either:
- Quick way: drop the measure into the matrix's Tooltips bucket.
- Nicer way: build a Report Page Tooltip - create a new page, set Page information → Tooltip = On and Page size = Tooltip, add a Card bound to the measure, then in the matrix's Format → Tooltip select that page.
Hovering a value cell will now show the description for that column. Totals/subtotals will show blank, which is expected.
Cheers,
Metrica Team
- krishnakanth240
Super User
Hi Davidmllu
Yes, it is possible but not automatic. As value comes from an unrelated table, matrix tooltip doesnot know which column’s context to use. You can create a measure that captures the selected energy ID using SELECTEDVALUE and then fetch the corresponding description via LOOKUPVALUE or TREATAS. This way, tooltip dynamically shows the correct description based on the cell context.
- lbendlin
You cannot control the tooltips for the column headers, only for the values.
v-ssriganeshCommunity Support
Hi Davidmllu,
Thank you for posting your query in the Microsoft Fabric Community Forum.
I reproduced your scenario in Power BI Desktop based on the model structure you described (two fields used in the Matrix rows through a link table, with values coming from a separate table).After testing, I was able to achieve the expected result by using a Report Page Tooltip with DAX measures. The tooltip dynamically displays the corresponding description based on the selected matrix item.
For your reference, I’m attaching the sample .pbix file used for testing. You can review the model, measures, and tooltip configuration and adapt it to your dataset.
Please note: this works when hovering over matrix values/cells. Tooltips on matrix column headers are not supported in the standard Matrix visual.
Best regards,
Ganesh Singamshetty- danextian
You cannot add a tooltip to the column header but you should be able to do it with values. However, if you're trying to change the tooltip and the columns are from different measures, the tooltip won't change depending on which measure is being hovered.
- v-ssriganesh
Hello Davidmllu,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
