Dax query parameters set up for paginated report

[Anonymous]

Hi All,

I am new to paginated reports.

I copeid Dax query from Desktop and trying to create parameters .

Can some one help me how to create a parameter in the below Dax query please.

I need parameters on PL GROUP & Month

Thanks

// DAX Query
DEFINE
VAR __DS0Core =
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
ROLLUPGROUP(
'LCS GL-Data'[PL Group],
'LCS GL-Data'[PL Item Description],
'LCS GL-Data'[GL Account],
'LCS GL-Data'[AccountDescription],
'LCS GL-Data'[Month],
'LCS GL-Data'[Sort Month Year],
'LCS GL-Data'[TransactionDate]
), "IsGrandTotalRowTotal"
),
"Total_Actual", 'LCS GL-Data'[Total Actual],
"PreviousYearCalc", 'LCS GL-Data'[PreviousYearCalc],
"MTD_Variance", 'LCS GL-Data'[MTD Variance]
)

VAR __DS0PrimaryWindowed =
TOPN(
502,
__DS0Core,
[IsGrandTotalRowTotal],
0,
'LCS GL-Data'[PL Group],
1,
'LCS GL-Data'[PL Item Description],
1,
'LCS GL-Data'[GL Account],
1,
'LCS GL-Data'[AccountDescription],
1,
'LCS GL-Data'[Sort Month Year],
1,
'LCS GL-Data'[Month],
1,
'LCS GL-Data'[TransactionDate],
1
)

EVALUATE
__DS0PrimaryWindowed

ORDER BY
[IsGrandTotalRowTotal] DESC,
'LCS GL-Data'[PL Group],
'LCS GL-Data'[PL Item Description],
'LCS GL-Data'[GL Account],
'LCS GL-Data'[AccountDescription],
'LCS GL-Data'[Sort Month Year],
'LCS GL-Data'[Month],
'LCS GL-Data'[TransactionDate]

[Anonymous]

Hi  @Anonymous ,

You may refer to this blog and video for more details and I hope they could help you solve your problem.

Blog1: Create parameters for paginated reports in the Power BI service

Blog2: Report parameters in Power BI Report Builder

Video: Power BI Paginated Reports in a Day - 11: Working with Parameters - Part 1

Best Regards,

Liu Yang

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