Forum Discussion

Adham's avatar
Adham
Icon for Helper III rankHelper III
5 years ago
Solved

Bar chart to filter slicer

Hello All,   I am trying to create a slicer that can be filtered by a bar chart. The data used for both the bar chart and the slicer are from the same table.   Here is a simplified data table for...
Need Help
  • Anand24's avatar
    Anand24
    5 years ago

    Hi Adham ,

     

    The bar chart can't drive/filter a slicer. You can use a simple table instead of slicer for being driven by the bar chart.

     

    Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

     
Anand24's avatar
Anand24
Icon for Super User rankSuper User
5 years ago

Hi Adham ,

 

The bar chart can't drive/filter a slicer. You can use a simple table instead of slicer for being driven by the bar chart.

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

 
  • rhaining's avatar
    rhaining
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    I have this same problem.  I appreciate the community answer but this is no solution.  I need the behavior of a dropdown slicer, so it normally doesn't take a lot of space on the page, but when you want to filter via that slicer, you can see the list.  But I also need the list of options in the slicer to shrink down to something managable based on the other selections the user has made on the bar chart and other elements and other slicers.  Like Excel filters when other filters have already been applied.  It's been several years since this post was made so I'm hoping there's a better solution now.