Select All items for Parameters in Power BI Paginated reports

Ever struggled with trying to get a parameter to select all items by default in a Power BI Paginated report? Patrick walks you through how to get this working!

Create parameters for paginated reports in the Power BI service


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #Paginated #GuyInACube

[MiguelMartinez-shgz]

YEAH !!!! Thanks for the video and responding to my request. Really appreciate it.

[TracerTube]

I LOVE your old school swagger. I think we're roughly the same age, which means you come from a time when devs were allowed to be a little cocky about our game. Keep that going man! I'm the same way! :)

[JohnySmith-lb]

You are my saviour today, I was frustrated with this thing, power bi dataset does not contain nulls but still the DAX query produced null row which prevented selected all. What the French Toast !

[natasharosell]

How do you handle if you do have a hierarchy??

[mbielby]

Thanks Patrick, great explanation in a quick video, you saved me again. Just thinking that process is a bit cumbersome for such a basic requirement. :).

[PRIYANKAPATEL-xs]

Hi Sir, how can we make mandatory parameter coming from HANA views dynamic in paginated reports.Please help

[tanababa]

Thank you for the video. Is it possible to keep the option allowing to type the search value? Meaning, use the pre-selected all values and....to be able to type my desired value?

[ahv]

Thanks for the video. How can we use a row level security based on the User ID/email in the paginated report? I am using [Email] = Username() for the RLS.

[tushar-sharma-]

Hi Patrick - Thanks for this Great Video.
But this is not working when we have multiple parameters in the report and those parameters are dependent on the previous parameter.
Could you help on this ?
If i have 3 parameters in the report then how to Default to Select All on all the 3 parameters ????

[yon_draper]

what if my query is coming from DAX that i copied from Performance Analyzer after refreshing my visuals ? is it possible to add a parameter when doing that ?

[hamtaf]

Hello, do we have a way to control the users' access to parameter options in the paginated report without a dataset?

[samson]

Good video, it solved my problem, but how about multi parameter (cascading) since it is cross filtered, so I need to write complicated dax for each parameter ? many thanks

[hydraulic]

If I have four parameters, how do I set select all as default? thanks

[akhilannan]

Rather than passing all the values to the query is there a way to just not apply the filter at all until some values are selected? (Similar to how Power BI Desktop works when select all is done on a filter/slicer)

[sheetalbarapatre]

Hi Patrick, How can i connect to you for knowing the solution to some of my problem statements. Not so difficult for you but I am stuck there for some reason?

[felixthecatx]

Hey Patrick, this is great. However, when I try to load this report into a Power Bi dashboard as a visual, the parameter selection is missing! I don't know why this is happening

[CollinClifford-ofvs]

How would I set up a multivalue parameter that needs to be able to select 'null' values as well? Thx!

[arsquad]

Hi, thanks for the great video. I had a question though which I am not able to find an answer to anywhere. Is it possible to concatenate 2 fields and use them as a parameter? I have been trying to do it and it keeps failing. Please create another video on using concatenating 2 values and using it as a parameter.

[michaeltangren]

This works well with ONE parameter, but how the french toast do you do it with more than one?!

[ClarksonFisherIII]

My workaround was to delete the [column] in the report builder designer and instead use an expression like IIf( Parameter = "", all, Parameter=[Column] )

I'm sure I'll soon realize why this is a bad idea :)