cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Carlaf
Frequent Visitor

create parameter in power bi report builder

Good morning, 

 

i'm creating a report with report builder.

I copied the DAX query from my published report. A table with two column STAT_VEN_QLIK'[DESC_SOTT] and 'STAT_VEN_QLIK'[DESC_ZONA].

 

This is the query:

 

// DAX Query
DEFINE
VAR __DS0Core =
SUMMARIZE('STAT_VEN_QLIK', 'STAT_VEN_QLIK'[DESC_SOTT], 'STAT_VEN_QLIK'[DESC_ZONA])

VAR __DS0PrimaryWindowed =
TOPN(501, __DS0Core, 'STAT_VEN_QLIK'[DESC_SOTT], 1, 'STAT_VEN_QLIK'[DESC_ZONA], 1)

EVALUATE
__DS0PrimaryWindowed

ORDER BY
'STAT_VEN_QLIK'[DESC_SOTT], 'STAT_VEN_QLIK'[DESC_ZONA]

 

I would like to insert a parameter that let me select the field 'STAT_VEN_QLIK'[DESC_ZONA] when i run the report

How should i insert it?

2 REPLIES 2
Carlaf
Frequent Visitor

I will explain better.

I have this table in the report:

Carlaf_0-1663055729311.png

I'm taking the DAX quert script and insert it in the power bi report builder:

Carlaf_1-1663055810495.png

This work well.

I would like to insert the field ZONA like a parameter.

Ifi use the where clause as suggested in the link that you shared i receive this message:

Carlaf_2-1663055907890.pngCarlaf_3-1663055931119.png

 

What's wrong?

 

Thanks 

C

v-henryk-mstf
Community Support
Community Support

Hi @Carlaf ,

 

You can read the following official documentation on how to create parameters in the report builder.

Tutorial: Add a Parameter to Your Report (Report Builder) - SQL Server Reporting Services (SSRS) | M...


Also, if you are confused about the creation process, please provide a screenshot and describe it so that I can answer it for you as soon as possible.


Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.