Displaying Text columns in Power BI Tool tips


In May Power BI added the ability to show custom tool tips in reports. Which is very cool if you what you wanted displayed was already in a measure.

In most cases though you don’t want the count of a text column but rather the text of the text column.  Such as the example below.

 

image

 

Turns out getting the Text to display isn’t terribly difficult, you just need to convert it to a measure.

To do this add a new measure to your table by clicking on Model> New Measure.

Then in the expression add something like the following two expressions:

Tootip = FIRSTNONBLANK('Table'[Name],TRUE)

or

Tooltip = TOPN(1, VALUES('Table'[Name]), [Name], ASC)

 

image

Of course it is likely will will want to construct something a little more sophisticated in which case CONCATENATEX works a treat!

Tooltip1 = CONCATENATEX('Table', [Name] & "" & [Date], ",")

 

image


Comments (3)

  1. Michael Meyer says:

    Awesome been wanting to do this for a long time and never new how to do it!

  2. Dustin Ryan says:

    This is a good tip. I also blogged about this tip and also included a twist on the formula to handle dealing with multiple values. Check it out and let me know what you think: https://sqldusty.com/2016/06/29/5-more-power-bi-tips/

  3. Chris says:

    Any thoughts on how this might work for a line chart with multiple lines? It just repeats the "name" for the first line for every line.

Skip to main content