Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Hi @Carlaf ,
You can read the following official documentation on how to create parameters in the report builder.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |