Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have a parameter _Column1 in which I show possible fields from my Sales table.
Example
DEFINE
VAR _Column1 = TREATAS({@pColumn1}, 'SalesTable'[Columns])
VAR _ResultSet =
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
ROLLUPGROUP('SalesTable'[Color] ), "ColumnTotal"),
'SalesTable'[Model]
EVALUATE _ResultSet
I would like to specify in paramter the field that would be then used in group by instead of 'SalesTable'[Color].
It could be any other field, I select in the parameter.
Example which is not working
DEFINE
VAR _Column1 = TREATAS({@pColumn1}, 'SalesTable'[Columns])
VAR _ResultSet =
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
ROLLUPGROUP(_Column1 ), "ColumnTotal"),
'SalesTable'[Model]
EVALUATE _ResultSet
That would be a big improvement for Paginated reports.
Who can we ask, if this is going to be developed?
Thank you!
Hi @mkavcic ,
Please refer to the following documents.
Create and use the paginated report visual
Paginated reports in Power BI: FAQ
If still does not help, please create an idea here and post this link for us to vote for it.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Not sure if Field Parameters are supported for Paginated Reports yet.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
21 | |
18 | |
14 | |
11 |
User | Count |
---|---|
43 | |
35 | |
25 | |
24 | |
22 |