Power BI – Report Builder using Multi Value Parameters in DAX

How to create a Multi Value Parameter Report in Power BI Report Builder

You can download PBI Report Builder here

This builder looks very familiar to the SSRS Report Builder you are used to from MS Reporting Services

Building a single value parameter in DAX is easy.

But creating a Multi Value Parameter requires quite some steps …

image

Solution :

These are the steps to follow :

1. Create a Data Set with the SLICER value in PBI Desktop

2. Copy the PBI Query

Run the Performance Analyzer in PBI Desktop

image

Start Recording and Refresh

image

Copy the Query to the Main Data Set

image

And apply the Filters in the next step …


3. Create new Parameter referencing to the Main Data Set Query Filter

To create a Parameter in the RBI Report Builder you first have to create a new Data Set

image

The same way go to the Performance Analyzer and copy the Query from the corresponding Slicer

image

And add it to the Filter Data Set and test the DAX.

image

3. Create a PBI Report Builder Report Parameter

image

Select the values from the Parameter Data Set created earlier

image


4. Add a Parameter in the Main Sales Data Set

image

 Add the @xxx Report Parameter variable in the DAX Query

Run the report and test the Report Parameters

image

Enjoy !!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: