custom tooltip based selected cell

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 

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

 

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.