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?
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!
Go to Solution.
Hi @X19203659 ,
You have two Card visuals with different count formulas. So you will need two tooltip pages.
View solution in original post
Many thanks for you quick answer!
I succeeded by creating two tooltips (one for each card) - see below
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!
You could create a table visual in tooltip page then create a measure to mark the corresponding records.
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.