topic Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip in DAX Commands and Tips

Tooltips is only showing the first value , need to show respective value of a record in tooltip

Suganthy — Thu, 27 Jan 2022 11:24:55 GMT

Hi All,

I wanted to show the respective record values in the tooltip, but I could see only the first value if I use that column in the tooltip, I have tried using the report page tooltip but I am seeing all the records with respect to that record, below is the screenshot attached

1. In the below image shows the first value of a record( Marketing) wherein it should show sales

2. while using the report page tooltip I could see all the records associated with that

Any help will be greatly appreciated.

Thanks & Regards,

Suganthy

Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip

ValtteriN — Thu, 27 Jan 2022 11:33:39 GMT

Hi,

I recommend creating a measure that returns the desired value and place this in the tooltip.

e.g.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip

Suganthy — Thu, 27 Jan 2022 11:36:18 GMT

I have tried creating a measure by using min /max function still couldn't get the desired output, its talking min of all records associated with that record

Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip

v-cazheng-msft — Tue, 01 Feb 2022 09:24:25 GMT

Hi Suganthy

Please create a Measure firstly and then use it as the Tooltip of this visual.

Depart =

VAR midVal =

DISTINCTCOUNT('Table'[Department] )

RETURN

IF ( midVal = 2, "Marketing&sales", MIN ( 'Table'[Department] ) )

Then, the result should look like this.

Also, attached the pbix file as reference.

Best Regards,

Community Support Team _ Caiyun

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip

Suganthy — Tue, 01 Feb 2022 09:44:54 GMT

Hi,

The issue is, I wanted to show what department each of them is associated for eg: "E" 's department is "sales"

but e is a parent for other people who are in sales so it shows both marketing & sales. Is there a way to show only the row-level value of that person?

Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip

v-cazheng-msft — Wed, 02 Feb 2022 06:55:01 GMT

Hi Suganthy

For regular Tooltip, It currently only supports displaying one-line record at a time. You may consider voting for similar idea in Power BI Ideas. Then, use report tooltip as you mentioned as a workaround.

Best Regards,

Community Support Team _ Caiyun

If there is any post helps, then please consider Accept it as the solution. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip

ljkeefe — Thu, 11 May 2023 14:48:03 GMT

ValtteriN I'm still somewhat new to PBI, can you share how you did that?

Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip

ValtteriN — Sun, 14 May 2023 08:57:22 GMT

Here is example data:

Simple measure = MAX('Table (32)'[Department])

When this is placed to a tooltip the decomposition tree will for example show department A for id's 1 and 2. Using MAX or e.g. SELECTEDVALUE will preserve the filter context and return the desired values instead of first value.

Re: Tooltips is only showing the first value , need to show respective value of a record in tooltip

ljkeefe — Tue, 16 May 2023 15:49:52 GMT

ValtteriN Thank you for sharing. It didn't work for me. When I put the MAX measure in the Tooltip, it just says MAX 1162. It must be something else I have going on that's conflicting with it. Thank you again!