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! 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?
Hi aj0903,
You need to have two values on the x-axis in order to create a hierarchy in the axis and being abble to do a drill down.
Regards.
MFelix
Hi MFelix,
I know that is possible like that, however I am trying to solve it the same way that austinsense did in his example.
