Forum Discussion
Basics Of Filter
Hello everyone,
I'm currently learning Power BI through various exercises, and I've already run into what seems like a simple issue that I can't figure out.
I recreated the two tables used in this tutorial Video as closely as possible. If anyone happens to have the complete dataset, I'd be very interested in getting a copy.
Before describing my issue, I also have a couple of questions about the video:
Is the "Period" visual a Card or a Slicer?
If it's a Slicer, how can I achieve the same appearance as shown in the video ?
My issue
When I select Period 1, the average doesn't change and remains 74.
When I select Period 2, the average disappears completely.
I assume there's something wrong with my data model, relationships but I can't identify the root cause.
How can I get the "Period" filter to work correctly?
Thank you in advance for your help!
Best regards
Hello.
In your student table, the students with period 2 have the keys 5,6,7,8. But in your Gradebook table, the student keys present are only 1,2,3,4. When selecting period 2, the grade book table filters itself to the coresponding students, but in your case, there will be no rows and hence the empty value. The same reason is why the average appears to be unchanged at 74.
Also from the video, the Period visual is indeed a slicer.You just have to go to the format pane > Slicer Settings > Options > Tile. Or you can used the button slicer visual(i am assuming this visual wasnt available at the time of the video release, please correct me if I am wrong) and go to Format Pane > Multi Button Layout > Layout > Arrangement > Vertical.
Hope this helps
2 Replies
Hello.
In your student table, the students with period 2 have the keys 5,6,7,8. But in your Gradebook table, the student keys present are only 1,2,3,4. When selecting period 2, the grade book table filters itself to the coresponding students, but in your case, there will be no rows and hence the empty value. The same reason is why the average appears to be unchanged at 74.
Also from the video, the Period visual is indeed a slicer.You just have to go to the format pane > Slicer Settings > Options > Tile. Or you can used the button slicer visual(i am assuming this visual wasnt available at the time of the video release, please correct me if I am wrong) and go to Format Pane > Multi Button Layout > Layout > Arrangement > Vertical.
Hope this helps
Hello aswathimohan ,
Thank you very much for your prompt reply.
I understand perfectly; there is indeed much more data missing than I realised.
I’ve also managed to change the appearance of the slicer.
Thank you very much.
Have a nice day.
