In attached Excel 2013 file there are multiple worksheets which are simplified and contain basic sample data. I am looking for an expert in Excel who has experience with data modeling and statistics. Knowledge of and experience with the (beta) Power BI suite of Microsoft (Power View and Power pivot) are recommended.
In the first sheet is a Powerview sheet with voting results (see attached screenshot). I would like to be able to create filters on the right side, for example age, location, gender, etc. In the screenshot you can see the age filter. However, the filter is not working. I can slide what I want but it doesn't update the voting results table. There are relationships created.
I need someone who is able to understand the data model and can help set me up with views like these working. Maybe by first consolidating the data in a Pivot table if that is the solution. Next to this view we are creating tens of other views so whoever can quick fix this issue there is more work to do on a continuous basis.