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

[Suganthy]

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

[v-cazheng-msft]

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!

[Suganthy]

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?

[v-cazheng-msft · Accepted solution]

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!

[Suganthy]

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

[ValtteriN]

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!

[ljkeefe]

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

[ValtteriN]

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. 

[ljkeefe]

@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!