Forum Discussion
Change visual with slicer
Hi obemo,
You can do it using the drill-down function in a visual, that way you don't need to use the slicer if you don't want to.
If you had the Team and the Player to your x-axis you then will see the options to drill down see the link below to understand it better.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/
If you mess around with the axis formating options you can also add the level of detail you want to see.
Regards
Mfelix
Hi Mate, how is your project coming along? I'm trying to build my own stats visual but sadly I am a novice to Power BI.
Hi! I haven't had the time to extend the project sadly, but I did implement the drill-down functionality to the report, and it works brilliantly. From getting an overview of e.g. goals scored per team in the PL, to clicking on a team and getting exactly who scored within the team. Pretty neat! You just have to find a dataset, and just start the trial and error phase, and you'll learn quickly
I was a little upset to see this marked as solved when it was only half solved. :smileyhappy: Here's the real solution ... https://powerpivotpro0-my.sharepoint.com/personal/austin_powerpivotpro_com/_layouts/15/guestaccess.aspx?docid=16cc47923a8aa494787579703201fad12&authkey=AU8EjyMdcfTskIfg1TNe_xk&e=d6deeee4e29c4a238327eb57092dcd5a
austinsense This is very helpful. I am trying to replicate something very similar to this, however, when I put the Name field in the chart axis, it is showing all of the values when nothing is selected in the slicer. What do I need to do to get it to only show, in your case, the team names?
