Forum Discussion

croberts21's avatar
croberts21
Icon for Continued Contributor rankContinued Contributor
3 years ago
Solved

How to add custom tooltip text to a query column?

I have PBI Desktop v March 2023. I would like to add custom tooltip text to a field in a query so it shows up when the user hovers their mouse over a column in a visual. I looked on the columns area for a visual, and I looked at the column properties in the query, and I don't see any way to add custom tooltip text for a field. There is a way to format the tooltip text but not add custom text. Right now the tooltip just displays the column name. I would like to explain a bit more of what the column is.

Is there a way to make custom tooltip text in a newer version of PBI?

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi croberts21 ,

    As far as I know, 

    there is no direct way to add custom tooltip text to a query column in Power BI Desktop. However, there are some possible workarounds that you can try.

    One workaround is to create a new column in your query that contains the custom tooltip text you want to display for each field. For example, you can use the Table.AddColumn function in Power Query Editor to add a new column with a formula like this:

    = Table.AddColumn(#“Previous Step”, “Tooltip”, each "This is the tooltip for " & [Field])

     Then, you can drag and drop this new column into the Tooltips bucket in the Fields pane of the Visualizations pane. This way, when you hover over a data point in your visual, you will see the custom tooltip text for that field.

     

    Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

    zebrabi.com

    zebrabi.com

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

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

     

     

     

3 Replies

  • Hello croberts21 ,

     

    although there's no custom tooltip text in the newer version of power bi but i advice you to get the newer version because from march till now many things have been changed / added.

     

    regarding the tooltip you can either drag a column or measure to the tooltip field or create a page tooltip and reference it to the visual.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin
    Vote for my Community Mobile App Idea 💡

    • croberts21's avatar
      croberts21
      Icon for Continued Contributor rankContinued Contributor

      Thank you, I will take your comments into consideration.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi croberts21 ,

    As far as I know, 

    there is no direct way to add custom tooltip text to a query column in Power BI Desktop. However, there are some possible workarounds that you can try.

    One workaround is to create a new column in your query that contains the custom tooltip text you want to display for each field. For example, you can use the Table.AddColumn function in Power Query Editor to add a new column with a formula like this:

    = Table.AddColumn(#“Previous Step”, “Tooltip”, each "This is the tooltip for " & [Field])

     Then, you can drag and drop this new column into the Tooltips bucket in the Fields pane of the Visualizations pane. This way, when you hover over a data point in your visual, you will see the custom tooltip text for that field.

     

    Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

    zebrabi.com

    zebrabi.com

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

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