PowerBIforSchools

One of the really powerful features of BI is being able to drill very quickly from the macro picture to the micro. To help schools do this with assessment results I've recently been working on this table showing subject, class and pupil level results (p2 of the report below). You can download the PBI file here , the class information looks like this  In a previous post I described concatenating studentid and subject to link classes, assessments and students, but that's not actually best practice - you can do it more simply with this setup I created the Subjects table using Dax (create table on the modelling tab). The formula is  Subjects = DISTINCT(AssessmentResults[Subject]). It gives a one column table with each distinct value of subject.  Note that here it is assumed that StudentClasses[Subject] isn't always the same AssessmentResults[Subject], as for example English Classes will often have English Literature Results. To handle t

Hi BI Team, Sorry I haven't posted in a while - I'm back working full time on BI so hopefully I'll fix that over the next few weeks. One thing that has been bugging me - literally - is the fact that applying a Bookmark to 'Selected Visuals' doesn't work as expected (the bookmarks just do nothing). This is super annoying as if you're trying to create a multipurpose dashboard it's useful to have bookmarks affect only part of the page. There is a workaround from user Denpries which you can find here https://community.powerbi.com/t5/Desktop/Bookmark-selected-visuals-bug-gt-almost-impossible-to-work-with/td-p/348111 Hopefully it'll get fixed soon.