Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Drive link to my Powerbi file and data
Thanks to a kind soul on here, I managed to get my data sorted and transformed to start to analyse it.
It's interest groups of students, along with certain measures across the years 2019-2023.
I'd love to show trends in these and compare across different subjects and groups. I've got really close, in that I can chose a year, measure, and students and it will plot a graph for that selection. What I can't do is put another plot on it. It just totals up my selections! Please help!
Solved! Go to Solution.
Thank you for your prompt reply! @Greg_Deckler
Hi @jgreen82
First, just as @Greg_Deckler Said, add Focus Group to the Legend. Then you just need to hold down the "Ctrl" key and select the "Focus Group" you need in the slicer like this:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, that displays everything, but then the slicers will only allow one selection?
Thank you for your prompt reply! @Greg_Deckler
Hi @jgreen82
First, just as @Greg_Deckler Said, add Focus Group to the Legend. Then you just need to hold down the "Ctrl" key and select the "Focus Group" you need in the slicer like this:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jgreen82 I downloaded and looked at your file but I have no clue what you are trying to accomplish, can you elaborate?
Thank you so much for your offer to have a look Greg. I'm trying to make it a bit more interactive than a spreadsheet we are used to! A head of department could select their subject(s) of responsibility and then compare the different student cohorts to see how progress had improved or not.
Quick sketch -
@jgreen82 OK, so add Focus Group to the Legend then?
User | Count |
---|---|
84 | |
80 | |
69 | |
46 | |
46 |
User | Count |
---|---|
106 | |
45 | |
42 | |
39 | |
39 |