Creating reports in Power BI with dynamic measures or dynamic dimensions
Part one of a three-part series of blogs

This blog shows how to create fully dynamic reports, whereby users can choose which statistics to show and which dimensions to report them by.

  1. Making Power BI reports dynamic (this blog)
  2. How to create dynamic measures
  3. Creating a Power BI report with dynamic dimensions

Posted by Andy Brown on 03 January 2019

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Making Power BI reports dynamic

A common request from Power BI training courses that we run is to make reports dynamic, so that a user can either choose the statistic to be displayed or choose the axis for a visual.  This blog shows how to do both!

Dynamic Measures - Overview

Here's an example of a dynamic measure:

Choosing statistic

You can choose the statistic to display, and the table (or any other visual) will update accordingly. Here we've gone for average price, but we could have chosen to show the number of sales or the total value of sales.

Dynamic Dimensions - Overview

This is more difficult.  We want to let report users choose what to chart by:

By centre type By product

For this blog you can either download the original reports and follow the examples, or just go straight to the answers.

This blog has 0 threads Add post