Published: 09 Jan 2020 | Author: James Honner
A great way to take your Power BI Reports to the next level is by making them fully interactive by incorporating PowerBI dynamic measures & dimensions. With this clever use of DAX, it’s possible to slice your data the way you want without leaving the dashboard screen.
In this 2-part series we’ll look at creating dynamic measures & dimensions within your PowerBI reports in part 1 and then continuing that into visual titles in part 2.
Using this concept greatly enhances the end user experience as they can monitor/analyse multiple measures and dimensions in a single report page at the click of a button making this a highly desirable solution.
In the PowerBI report example below, we have a financial dataset which includes revenue, expenses & taxes and from these we can calculate profit. We have created 1 set of measures for profit, revenue, expenses & taxes and 1 dimension for the time periods Fiscal Year to Date (FYTD), Quarter to Date (QTD) and Month to Date (MTD).
This will allow end users to view, as seen in the examples below, Profit by FYTD or QTD or MTD as well as the variances to the previous FYTD or QTD or MTD and all the visuals and visual titles will update when a different measure or time period is selected.
There are quite a few steps involved to get this concept up & running but the benefits to your report consumers will be well worth the effort.
Dynamic Measures table
Dynamic Dimensions table
Below is the Time Selected measure.
Bringing it all together
Using your preferred slicer, in this example the Chiclet Slicer (available via the PowerBI Marketplace), we create 2 slicers, one for the Selected Measure and one for Selected Time. These slicers allow your report consumers to dynamically change measures & time periods within the report page.
Below is the Selected Measure Chiclet Slicer.
With all the setup now complete, we create the visuals for the report page using either or both the Selection 1 and Selection 2 measures and you’re done!
If you’d like to take your PowerBI Reports and Dashboards to the next level and need help, please contact us to discuss how we can assist your organisation.
Get the latest Talos Newsletter delivered directly to your inbox
Automation & Analytics Technologies for Business
Using our EPIC methodology guiding you to deliver outcomes quickly and cost effectively.
Specialising in all customer-related processes, she has been trained to quickly learn specific customer processes.
Enable self service analytics to meet the needs of the whole organisation with our proven methodologies.
Build, test and implement Data Platform components - secure, efficient, flexible and cost effective.