560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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!
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.
This is more difficult. We want to let report users choose what to chart by:
|By centre type||By product|
|Parts of this blog|
25 Aytoun Street