Forum Discussion
Tooltip per column in a matrix
- 4 months ago
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
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