Forum Discussion
Line and Clustered Column Chart filter problem
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.
Using a slicer I got the result I needed, I wanted to use another table, but thanks anyway.
3 Replies
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 quicklyThanks 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.
Using a slicer I got the result I needed, I wanted to use another table, but thanks anyway.
