Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
X19203659
Frequent Visitor

How to show card info when hover on card - Power BI Desktop

Hi team,

Is it possible to get select info when hovering on a card - ie. with below 2 cards, hover on red card show 1 employee name, hover on orange card show 4 employee names?

X19203659_0-1657301202717.png

I tried both 'blank button' using a measure and 'tooltips' and they didn't work.
With 'blank button' I can't find the correct formula returning list of employees in the measure.

With 'tooltips' I get full list of employees instead of just 1 or 4.

Grateful for any help with this?  Thanks in advance!

1 ACCEPTED SOLUTION

Hi @X19203659 ,

 

You have two Card visuals with different count formulas. So you will need two tooltip pages.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

3 REPLIES 3
X19203659
Frequent Visitor

Hi Jay,

 

Many thanks for you quick answer!

I succeeded by creating two tooltips (one for each card) - see below

X19203659_0-1657535072589.png

X19203659_1-1657536268233.png

 

 

I am a new Power BI user and have follow on query re above - if you could assist (sorry!)?

What I am trying to achieve is to show the employees per their year of retirement. 

In my table I have only 2 fields (employee name, retirement date).

Instead of creating 2 tooltips, is it possible to perform the same by creating only one tooltip and, if yes, do you mind to sharing a practical example?

Many thanks in advance for your support!

Guillaume 

Hi @X19203659 ,

 

You have two Card visuals with different count formulas. So you will need two tooltip pages.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
v-jayw-msft
Community Support
Community Support

Hi @X19203659 ,

 

You could create a table visual in tooltip page then create a measure to mark the corresponding records.

For example: 

count_measure = calculate(count(column1),column2=selectedvalue(column3))

mark_measure = if(selectedvalue(column2) = selectedvalue(column3),1,0)

Add the mark_measure to the table visual filter on tooltip page and set value =1.

Then use this tooltip page as the tooltip of the card visual.

Once select the slicer, the card visual will display the count of value based on count_measure. And the tooltip will show the filtered table visual on tooltip page based on the mark_measure.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.