custom tooltip based selected cell

[NadeemAhamed]

Hello.

I have created one table or matirx visual. 

we have highlights some cell for the particular month slicer. 

is it possible to add custom note/tooltip and when user hover the curser on that cell note/tooltip popup should come as like excel. 

[v-xinruzhu-msft]

Hi,

Thanks for the solution rajendraongole1  and bhanu_gautam  offered, and i want to offer some more information for user to refer to.

hello @NadeemAhamed , based on your description, you can refer to the following sample.

Sample data 

And i create two measures.

Color =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table'[Type] ) = "A", "red",
    SELECTEDVALUE ( 'Table'[Type] ) = "B", "blue",
    SELECTEDVALUE ( 'Table'[Type] ) = "C", "green"
)

Tooltip =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table'[Type] ) = "A", "it's A",
    SELECTEDVALUE ( 'Table'[Type] ) = "B", "it's B"
)

Then for the first requirement, can create a table visual, then click the conditional formatting, and select background color.

Then put the color measure to it.

Output 

And you can refer to the following link to know about the conditional formatting.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

powerbi - How to conditionally format a row of a table in Power BI DAX - Stack Overflow

For the second requirement, add a new page and allow it  as tooltip.

Then set it actual size as tooltip.

Then add a card visual and put the tooltip measure to the visual.

The return the page that display the table visual, then open tooltip, and select report page, and select the page which set as tooltip.

Output

And you can refer to the following link to know more about the custom tooltip.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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

[rajendraongole1]

Hi @NadeemAhamed - In Power BI, you can add custom tooltips to specific cells or values in a table or matrix visual, though it won't look exactly like Excel's comment tooltips.

Suggest you below stepup to configure the same using tooltip page for matrix visual

steps FYR:

In Power BI Desktop, create a new page specifically designed for tooltips>>Go to the page settings (the paint roller icon in the Visualizations pane).>>Under Page information, enable the Tooltip option>>Adjust the page size to "Tooltip" (320x240 pixels is a common size).

On this tooltip page>>You can use conditional formatting or measures to display dynamic text based on the context, such as the highlighted cells.

In Power BI, tooltips are generally limited to entire rows or fields rather than individual cells.

I hope this works in your scenerio

[NadeemAhamed]

@rajendraongole1 

Thank you rajendra for your valuable reply 

i have followed your steps. 

but iam not able to find the options to add the conditional formatting or measures to display dynamic text based on the context, such as the highlighted cells. with the background color

I would greatly appreciate your prompt response to this topic.

[bhanu_gautam]

@NadeemAhamed , Try using

Create a Tooltip Page:

In Power BI Desktop, go to the "Report" view.
Click on the "+" icon to add a new page.
Rename the page to something like "Custom Tooltip".
In the "Page Information" pane, toggle "Tooltip" to "On".
Set the page size to "Tooltip" under the "Page Size" settings.

Design the Tooltip:

On the tooltip page, add a text box or any visual that contains the message "reason: Due to some technical issue".
Set Up the Tooltip in the Table/Matrix Visual:

Go back to the main report page where your table or matrix visual is located.
Select the table or matrix visual.
In the "Visualizations" pane, go to the "Format" section.
Expand the "Tooltip" section and set "Type" to "Report page".
Select the tooltip page you created from the dropdown menu.
Add Conditional Tooltip Data:

Create a new measure or calculated column to conditionally show the tooltip for the value 23.

For example, you can create a measure like this and update as per you condition
TooltipMessage =
IF(
SELECTEDVALUE('YourTable'[Current actual]) = 23,
"reason: Due to some technical issue",
BLANK()
)
Add this measure to your table or matrix visual

g 

[NadeemAhamed]

@bhanu_gautam 

Thank you for detailed explaination.

I already have measures to add background color for the particular cells based on the month slicer. 

Ex: 

Table1_BG_color =

VAR _Month=SELECTEDVALUE('Financial Year'[Month])

VAR _company=SELECTEDVALUE(PV_CompanyList[Company name])

VAR _Planactual = SELECTEDVALUE(PV_Category[Plan/Actual])

RETURN

SWITCH(

    TRUE(),

    _Planactual = "rate(%)w.r.t. Plan",

      IF(_Month= "Sep" &&  (_company="TKM - Total (A+B)" || _company="Muruti Suzuki - Total"||_company="Suzuki Motor Gujarat - Total"),"#66FFCC","#FDE9D9")

    )

I have followed your steps and i can see the tooltip if i hover the curser on the cells but i have doubt should i create new measure for the tooltip and where to add that or shall i add that into my backgroud color. measure. 

[NadeemAhamed]

Any body have any idea?

request your support on this