create parameter in power bi report builder

[Carlaf]

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?

[Carlaf]

I will explain better.

I have this table in the report:

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

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:

What's wrong?

Thanks 

C

[v-henryk-mstf]

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.