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.
Dear all,
I am experimenting with some Premier League statistics, and I would like the report to be more user friendly. At the moment I have this:
When I select a team with the slicer, I would like the x-axis of the visual to change from [Team] to [Player] on that selected team. At the moment I only get this:
My columns are [Cost], [Player], [Points] and [Team] (and one Measure that displays the selected team in the card above the graph).
Additionaly question: Is it possible to also change the type of visual depening on selection of the slicer (i.e. HASONEVALUE)?
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi 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. Here's the real solution ... https://powerpivotpro0-my.sharepoint.com/personal/austin_powerpivotpro_com/_layouts/15/guestaccess.a...
@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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix,
I know that is possible like that, however I am trying to solve it the same way that @austinsense did in his example.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI realise now that this can quite easily be done by having a visual of Points by Team, instead of the slicer, and then have another visual with Points by Player.
But the original question is still interesting, as imagine the aesthetics might be a bit smoother
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 |
---|---|
114 | |
100 | |
74 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |