How to get the hover cell row and column header in a table visual in tooltips report ?

[Aiya]

In my power BI Dashboard, I have a visual table which showing columns from measures.

I want to show details report when user hover any cell in this table using tooltips, but how to get the hover cell row and column header ? 

[Aiya]

Thanks @Ritaf1983 

what I want is when user hover any cell, like the one in above, how can I get the cell is "Paper" category and column is "Profit" ?

Thanks

[Ritaf1983]

@Aiya 
Then turn your table to the matrix. 
This is a basic matrix tooltip :

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Aiya]

The default tooltip for the Table provides the information I need.
However, instead of using the default tooltip, I want to display a chart as a customized tooltip based on the row value and column header. The challenge is that I don’t know how to retrieve the column header. Additionally, the column data is dynamically generated, not sourced from a data table.

[Ritaf1983]

@Aiya 
You can use selectedvalue() like i used in my customized tooltip for the title :

This I a title dax :

Tooltip title = "YOY revenue change details of " & SELECTEDVALUE('multi graph'[Item])

and you need the separate tooltip for every wanted measure 

that the engine will take based on measures like drilling through

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Aiya]

In my Power BI table (suppose it is 6 rows x 4 columns):

The rows represent demographic groups: "Youths," "Adult," "Elderly," "Female," "Male," "Overall."

The columns are "Demographic Group," "Any Contact," "Mental Health Contact," and "Non-Mental Health Contact."

- Column 1: Groups, from DemographicGroup[groups].

- Columns 2–4: Measures. (by changing the contact type below).

PercentageOfAnyContact = 

    RETURN

    SWITCH(

        SELECTEDVALUE(DemographicGroups[Group]),

        "Youths", DIVIDE(

            CALCULATE(

                SUM(contact_history[contact_value]), 

FILTER(

ALLSELECTED(contact_history), 

contact_history[age_group] = "Youths"

), 

                contact_history[contact_type] = "Any Contact", 

                contact_history[period] = "1-year"

            ), 

            CALCULATE(

                DISTINCTCOUNT(contact_history[patient_id]), 

FILTER(

ALLSELECTED(contact_history), 

contact_history[age_group] = "Youths"

) 

            )

        ),

        "Adult", DIVIDE(

            CALCULATE(

                SUM(contact_history[contact_value]), 

FILTER(

ALLSELECTED(contact_history),

contact_history[age_group] = "Adult"

), 

                contact_history[contact_type] = "Any Contact", 

                contact_history[period] = "1-year"

            ), 

            CALCULATE(

                DISTINCTCOUNT(contact_history[patient_id]), 

FILTER(

ALLSELECTED(contact_history),

contact_history[age_group] = "Adult"

) 

            )

        ),

        "Elderly", DIVIDE(

            CALCULATE(

                SUM(contact_history[contact_value]), 

FILTER(

ALLSELECTED(contact_history),

contact_history[age_group] = "Elderly"

), 

                contact_history[contact_type] = "Any Contact", 

                contact_history[period] = "1-year"

            ), 

            CALCULATE(

                DISTINCTCOUNT(contact_history[patient_id]), 

FILTER(

ALLSELECTED(contact_history),

contact_history[age_group] = "Elderly"

) 

            )

        ),

        "Male", DIVIDE(

            CALCULATE(

                SUM(contact_history[contact_value]), 

FILTER(

ALLSELECTED(contact_history),

contact_history[gender] = "Male"

), 

                contact_history[contact_type] = "Any contact", 

                contact_history[period] = "1-year"

            ), 

            CALCULATE(

                DISTINCTCOUNT(contact_history[patient_id]), 

FILTER(

ALLSELECTED(contact_history),

contact_history[gender] = "Male"

) 

            )

        ),

        "Female", DIVIDE(

            CALCULATE(

                SUM(contact_history[contact_value]), 

FILTER(

ALLSELECTED(contact_history),

contact_history[gender] = "Female"

), 

                contact_history[contact_type] = "Any contact", 

                contact_history[period] = "1-year"

            ), 

            CALCULATE(

                DISTINCTCOUNT(contact_history[patient_id]), 

FILTER(

ALLSELECTED(contact_history),

contact_history[gender] = "Female"

) 

            )

        ),

        "Overall", DIVIDE(

            CALCULATE(

                SUM(contact_history[contact_value]), 

ALLSELECTED(contact_history),

                contact_history[contact_type] = "Any contact", 

                contact_history[period] = "1-year"

            ), 

            CALCULATE(

                DISTINCTCOUNT(contact_history[patient_id]),

ALLSELECTED(contact_history)

            )

        ),

        0

    )

Question: How to Determine the Hovered Column? Will need to know which demographic group and which "contact_type" hovered to produce a detailed chart as tooltips

[Ritaf1983]

Hi @Aiya 

Tooltips in Power BI currently work only with measures, specifically on values in visuals like tables or matrix visuals. Unfortunately, it's not possible to directly show tooltips for row or column headers.

As an alternative, you could use a workaround by placing a transparent button (or one with a small icon) near the headers or specific areas. You can configure the button to show a tooltip with the explanation when hovered over. While not ideal, this provides a functional way to convey the information you're looking to highlight.

Same approach with "i"

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.