Our data model that you can explore in the template app, is highly optimized for an easy analytical experience. Please follow the steps described here , on how to download and explore the Power BI template app in Power BI desktop.
In Power BI desktop open the transform data dialog
All the tables loaded in this step, are simply tables from our OData API- no transformations are done
All data transformation step is done with 1 virtual table, using the DAX language. Our fact table is transformed here
If you are new to DAX this might look scary, but it's not that tricky. Our fact table is cross-joined to create a period concept. This makes it very easy for you as a Power BI developer to build a visualization showing the compliance percentage development over time - regardless of the specific locations' compliance percentage was actually modified in the time period.