Forum Discussion
Paginated Report - Using URL Parameters and Select ALL
Ok, after much investigation and great support from Microsoft, we found the solution and it was dead simple!
Set the paginated report up so all parameters are loaded with Default values from the dataset. And then for the URL string passed from the calling Power BI report, only reference a parameter if the user has actually selected a value from a slicer. If the user has selected no values from any slicers (eg Select All), then simply submit the default Paginated Report URL string. If a user has selected a value from a slicer, then modify the URL to include a reference to that particular parameter and its selected values.
To build a multi select drop down box in a paginated report. Takes quite a few steps which are not so easy to figure out...
Therefore I created a step by step guide on how to :
https://audministrator.wordpress.com/2019/12/20/power-bi-report-builder-using-parameters/
Hopefully this can help !
Thanks for the input and the guide. However my Paginated Report does already have this functionality - please download the example rdl file I supplied. When you run the report you will see there is a dropdown called Site. Here I can successfully select one, a few or Select All and the report works.
The query is, here can I select all values when calling the Paginated Report from my Power BI report, using the URL Parameters. The Guy in a Cube video, demonstrates with just a single value being supplied. However you can concatenate the values together, but there is a limit before the URL fails. I am hoping there is a way, using URL Parameters, to 'Select All' and not have to pass seventy, eighty individual values in the URL string.
Thanks
Mark
Is this is not a working solution where you test on whether the parameter value is NULL (Empty).
And next create a DAX condition that if it is NULL you will take 'ALL' all a default value.
Example :
https://prologika.com/ssrs-multivalue-parameters-in-dax/
EVALUATE
SUMMARIZECOLUMNS (
‘Date'[Fiscal Year],
FILTER (
VALUES ( ‘Date'[Fiscal Year] ),
(
OR (
( @DateFiscalYear = “All” ),
PATHCONTAINS ( @DateFiscalYear, ‘Date'[Fiscal Year] )
)
)
),
“Internet Total Sales”, [Internet Total Sales],
“Reseller Total Sales”, [Reseller Total Sales]
)Ok, after much investigation and great support from Microsoft, we found the solution and it was dead simple!
Set the paginated report up so all parameters are loaded with Default values from the dataset. And then for the URL string passed from the calling Power BI report, only reference a parameter if the user has actually selected a value from a slicer. If the user has selected no values from any slicers (eg Select All), then simply submit the default Paginated Report URL string. If a user has selected a value from a slicer, then modify the URL to include a reference to that particular parameter and its selected values.
Hi MarkSL, I see that you can select multiple values in your paginated report. In my paginated report I have a parameter (text but with no available or default values) which can have multiple values. The problem is a parameter with multiple values in a paginated report is written with a line break between the values, but when I import the values of the parameter from my dashboard in Power BI, the parameters are written in a list (Y,N for example), so the values are not detected and I have a blank report. Also, if I add some available values so that I can have a dropdown, none of the selected values are detected in my paginated report. I hope you can help me with this. Thank you in advance!
Hi,
From remote it's hard to figure out what is going wrong ?
But did you get all the settings an correct in your report to build the proper parameter settings?
I definitely can recommend this video (if you have not seen it yet) on how to get started to make sure all settings are correct.
https://www.youtube.com/watch?v=XA5twJ2wLd0
Once you have the parameter dataset correct in your report, you can run a query on the HIDDEN PARAMETER DATASET to further debug the isseu.
