Forum Discussion

Carlaf's avatar
Carlaf
Frequent Visitor
3 years ago

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?

Help

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    3 years ago

    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) | Microsoft Docs


    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.

  • Carlaf's avatar
    Carlaf
    Frequent Visitor
    3 years ago

    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