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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jja
Helper III
Helper III

Tooltop page shows all transactions with record

Hi

I havea report tooltip page and when i hoover it on a cell with particular transaction it should show only that cellk transaction but instead it shows all. Ho do i limit a tooltip to a certain treanaction.

I am working with Matrix visual and in values i calculate my transactions something like this:

Atkrovimas =
CALCULATE(
    COUNT(new_transactions[Darbo tipo nuoroda])+0,
    new_transactions[Darbo tipo nuoroda]="atkrovimas"
)
Total i have 6 values.
So as mentioned if i hoover on any of new_transactions[Darbo tipo nuoroda]="atkrovimas" tooltip. shows me all new_transactions[Darbo tipo nuoroda].
How do i limit to certain cell value?
3 REPLIES 3
Anonymous
Not applicable

Hi @PijushRoy ,

Thank you  for your prompt reply! I have some information to add.

 

Hi  @jja , please refer to my pbix file to see if it helps you.

It is a column.

Atkrovimas = 
CALCULATE(
    COUNT(new_transactions[Darbo tipo nuoroda])+0,
    new_transactions[Darbo tipo nuoroda]="atkrovimas"
)

vrongtiepmsft_0-1713234966964.pngvrongtiepmsft_1-1713234975141.png

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

 

Hi @Anonymous @PijushRoy 

Please find link to demo file. if you hover over matrix cell you will see it shows all work types not matter to which work type cell you hover. I know i can have this type1 in one DAX expresion and puting work type into Columns but i cant as i have some other Type1 more complex expresions in the matrix

Link to pbix 

PijushRoy
Super User
Super User

Hi @jja 

When you have created a tooltip page, by default the filter is always applicable on the tooltip page
If you are using a different table, please check proper relationship is working or not.

Please create a sample pbix file with sample data (the model and table patter should match with your existing report) and share the PBIX file link (Google Drive, Dropbox, onedrive etc)

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors