Bar chart tooltip to be filtered on one column of table visual.

[IAmAPowerBIUser]

Hi, 

I have a table visual in Power BI which shows me for the most recent entry from an invoice table for every subscription of the subscription table.

I also have a bar chart tooltip when I hover over the table visual. the y axis shows the invoiced amount and there is time (months and years) on the x axis.

now the bar chart tool tip only shows the most recent invoice.

is it possible to filter the bar chart visual in a way that it only filters based on the "subscription No" column of the table visual? So I want all invoice amounts over time for a give subscription no to be displayed in the bar chart. If it is only possible to do this for a visual on the same page instead of a tooltip this would also help me a lot already. thanks a lot already for all your help! 

You can find my pbix file on we transfer for more details.

https://we.tl/t-NSxSJIA7OD

[IAmAPowerBIUser]

thanks a lot. This works very well!

[v-yueyunzh-msft · Accepted solution]

Hi， @IAmAPowerBIUser 

Thanks for your sample pbix file very much!

For your need , you want to  your tooltip page just be filtered by the [Subscription No].

You can first unselect the "Keep all filters" and then pull the [Subscription No] below it .

And then you can meet your need:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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