BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
This blog shows how to create fully dynamic reports, whereby users can choose which statistics to show and which dimensions to report them by.
- Making Power BI reports dynamic (this blog)
- How to create dynamic measures
- 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:
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.
- Making Power BI reports dynamic (this blog)
- How to create dynamic measures
- Creating a Power BI report with dynamic dimensions