Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Using a Visuals data as slicer

Hi there, 


I'm trying to figure out how I can use the output on visual as a splicer. 


Below you will see different names (user id). The graphs already has a relation so it filters all the users accoring to a certian reason, when clicking on one of the bards.


Then I use the filter fuction by using TopN on the desktop option, get the top 10 users effected by the reaons. 



Annotation 2020-05-27 100026.png


However, not that I have the top 10 names affected by the reason I want to use the top 10 names to use as a slicer so I can drill down into each of the top 10 users individually. 


Any ideas? Maybe missing a best practice? 






Community Support
Community Support


As far as I know, you can not make the table visual works as a slicer to filter a bar chart.

As an alternative, you may use a line chart instead, when select a role on the table visual the line graph will be filtered and drill down to the selected category only.


table slicer.JPG


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @V-pazhen-msft - thanks for the below. Yes I figured that you cannot make the table visual work as a filter after many hours😀. But thanks for the below, I will give it a go in future. 


I managed to complete my report by using the button (ctrl+click) to next page after selection data (a bar) and this was good enough for now. 


Many thanks for you time in giving the suggetion. 


Best Regards


Many thanks for the links, it was very usefull and very well presented (very clear), and helped a great deal on my learning curve. 

However, I could not use it as my solution, I ended up using the drill through option with buttons. 


Best regards,


Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!