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?
@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 TeamIf 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.
@niel_orvyn1 , Rank should help you .
For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finalehttps://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
Proud to be a Super User!
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.
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!