Forum Discussion

NadeemAhamed's avatar
NadeemAhamed
Helper V
1 year ago

custom tooltip based selected cell

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 ...
Need Help
bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

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's avatar
    NadeemAhamed
    Helper V
    1 year ago

    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's avatar
      NadeemAhamed
      Helper V
      1 year ago

      Any body have any idea?

      request your support on this