Line and Clustered Column Chart filter problem

[JoaoPedroSCC]

Hello People! I need help with a chat I'm making, it is kinda big so I had to configure it to show less values on screen, each one of the separated values is related to a company, because of that I wont be sharing the images containing the companies name, but I will explain what is the help I need.

I created a filter to select only one of the companies on the chart, however when I do so, if the company is not already showing in the chart it doesnt automatically go to it, here is the chart with the companies:

I made it smaller to show less information at the same time:

When I select a company on the filter that is already showing on the screen, it works fine:

But when I select one that isnt there it shows it like this:

Is there a way to make it so when I select a company it autofocus on them on the chart? Or a way to when I select it, the other companies disapear from the chart?

Thanks in advance.

[Ritaf1983]

Hi @JoaoPedroSCC 
If I understood you correctly, you can use include /exclude options, if the "companies " are x-axis values :

Results of include (after selection of 3 products) :

Exclude is the same, just filter them out .
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[JoaoPedroSCC · Accepted solution]

Using a slicer I got the result I needed, I wanted to use another table, but thanks anyway.

[JoaoPedroSCC]

Thanks for the reply, however I have a separated table with the names I need to filter, when I select one I needed it to change the chart focus automatically:

Company Name

Example Company 1

Example Company 2

That is an example of what it looks like, when I select one of the companies it focus it on the chart, but I wanted to know if there is an option to auto exclude it from the chart when I select it, or instead of excluding, just moving the scrollbar to show the focused result.

Thank you.