Tooltop page shows all transactions with record

[jja]

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?

[Anonymous]

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"
)

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.

[jja]

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]

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