This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

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. Making Power BI reports dynamic (this blog) How to create dynamic measures Creating a Power BI report with dynamic dimensions

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.

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

In this blog

Dynamic Measures - Overview
Dynamic Dimensions - Overview

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.