Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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.
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
@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...
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |