12-26-2017 20:56 PM
Test your football (soccer) knowledge with the Premier League Quiz!!
Showcasing the new bookmarking functionality
Any questions, give me a shout
Great Work !!
Can you please tell how do you store the selection of answers? Have you created a measure for each question or what?
It would be great to know the building blocks of creating these kind of reports.
Right from deciding schema of the model till creation of measures it would be great to learn. I think you should write a blog on this and share with the entire community. Kudos!
Each selection / slicer feeds into it's own table (eg Q1 table, Q2 table, Q3 ....and so on). Those selection are held throughout the report by deselected the 'data' option within each boomark.
Each table then has a measure or two relating to it's content. For example, "q1_single_name = if(HASONEVALUE('Q1'[Image URL]), FIRSTNONBLANK('Q1'[Player name], 'Q1'[Player name]),"")" which just helps with displaying the single selection made by the user.
I'll be more than happy to create a blog on this and break down exactly what has been done step-by-step and also share the pbix itself. I just need to clean up some of the presentation in the model
Hope that helps 🙂