Forum Discussion

Davidmllu's avatar
Davidmllu
Regular Visitor
4 months ago
Solved

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...
  • metrica's avatar
    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