Using a Visuals data as slicer

[niel_orvyn1]

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. 

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? 

Thanks

[Anonymous]

@niel_orvyn1 

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.

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.

[niel_orvyn1]

Hi @Anonymous - 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

[amitchandak]

@niel_orvyn1 , Rank should help you .

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[niel_orvyn1]

@amitchandak 

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,

Niel