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! :)
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 !
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. :).
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 ????
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
Thanks for the vídeo! I would like to pass date type parameters to query a semantic model. But I can't! Report Builder gives an error. It wrongly thinks the variable is of the text type! I need to study more DAX.... For now I'm using an SQL query... ... I wanted to read from the semantic model with DAX...
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)
@@GuyInACube only if you have a default set no? If you have no default it won't pass all values and won't let you run the report. Is there a way to code it so that it makes a parameter optional and then passes all values if you don't enter anything, preventing the RSCustomDaxFilter from maxing out if you have a long list of options.
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?
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.
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
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 ?
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.
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?
yeap, I had the same requirement, and this didn't work for me. I tried this approach ruclips.net/video/dZ3TLo1Yplk/видео.html It won'r show list of values for the parameter but you can have any number of Optional params
Thank you for your informative videos Patrick. I have a Paginated report which has 5 cascading parameters and all of those are multiselect (the last one being the address field - multiselect again). I added a Power BI dataset to this report and embedded the paginated report into Power BI report. I am stuck with the URL length limitation (2k chars). Is there any way I can use my Power BI report for users to play with the interactive power BI report and once they have selected all their options in slicers, I can have the same selection carried over to the paginated report and export the excel format? Thanks again!
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 :)
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! :)
YEAH !!!! Thanks for the video and responding to my request. Really appreciate it.
How do you handle if you do have a hierarchy??
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 !
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. :).
Hi Sir, how can we make mandatory parameter coming from HANA views dynamic in paginated reports.Please help
If I have four parameters, how do I set select all as default? thanks
did you find any solution for this?
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 ????
@@tushar-sharma-15 refer to my comment above if you are still looking out for solution
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
You correct, you would need to write DAX that does the cascading. I will add it to the list of videos.
@@GuyInACube looking forward to it ! haha
@@GuyInACube Just wanted to follow-up to see if you have had a chance to get to this video yet as I'm also having the same request. Thanks
Hi Samson can you please provide dax for multi parameters (cascading)
Thanks for the vídeo!
I would like to pass date type parameters to query a semantic model. But I can't!
Report Builder gives an error. It wrongly thinks the variable is of the text type! I need to study more DAX....
For now I'm using an SQL query...
... I wanted to read from the semantic model with DAX...
Hello, do we have a way to control the users' access to parameter options in the paginated report without a dataset?
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)
Yes. That is how it behaves by default.
@@GuyInACube only if you have a default set no? If you have no default it won't pass all values and won't let you run the report. Is there a way to code it so that it makes a parameter optional and then passes all values if you don't enter anything, preventing the RSCustomDaxFilter from maxing out if you have a long list of options.
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?
The items is being selected but not getting all items related report/
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.
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
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 ?
Fantastic thank you so much.
How would I set up a multivalue parameter that needs to be able to select 'null' values as well? Thx!
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.
Hi I am facing same issue for multiple parameters if you have solution please provide me for more than 2values thanks in advance
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?
I'm not getting select all auto selected, it still makes me select it from the dropdown
got other params in the report, so maybe that's causing it?
Filtering your parameter query to exclude nulls does it.
SRSS can't handle nulls in (multi) select and just gives up
I tired this method but I seem to keep getting one null value still
This works well with ONE parameter, but how the french toast do you do it with more than one?!
Agreed.
yeap, I had the same requirement, and this didn't work for me. I tried this approach ruclips.net/video/dZ3TLo1Yplk/видео.html It won'r show list of values for the parameter but you can have any number of Optional params
Thank you for your informative videos Patrick. I have a Paginated report which has 5 cascading parameters and all of those are multiselect (the last one being the address field - multiselect again). I added a Power BI dataset to this report and embedded the paginated report into Power BI report. I am stuck with the URL length limitation (2k chars). Is there any way I can use my Power BI report for users to play with the interactive power BI report and once they have selected all their options in slicers, I can have the same selection carried over to the paginated report and export the excel format? Thanks again!
Do you have a solution? I need same things. I think we have to put some value in default
How to sort the values in the parameter alphabetically?
Simply use ORDER BY clause
You looks like Will Smith, thanks for the video man 🙌
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 :)