topic Re: Ignore parameter value if its all selected for URL filtering on report server in Report Server

Ignore parameter value if its all selected for URL filtering on report server

Anonymous — Wed, 06 May 2020 15:39:39 GMT

I have 5 parameters set up as multivalue and default value is set to available values so that when the report is rendered (Selected All) is seleted. On powerbi I have action button that has a dynamic dax for URL and parameter value :

http://reports:8080/PowerBIReports/report/Private%20Wealth/Customer%20Restraint?Region=ABC&Channel=FX123&rs:Command=Render

The above works but if my dax selected value for channel is (blank) in other words nothing selected I dont want it to change the value passed to the power bi paginated report to " " because the report wont render

How can I dynamically manage this without changing from multivalue option?

Thanks

Re: Ignore parameter value if its all selected for URL filtering on report server

Greg_Deckler — Wed, 06 May 2020 15:46:12 GMT

I'm not fully getting this but I don't understand why you can't just have defaults if nothing is selected. See this example:
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer-Title-Measure-Ever/td-p/429587

Re: Ignore parameter value if its all selected for URL filtering on report server

d_gosbell — Mon, 11 May 2020 00:54:52 GMT

I would have thought that if you want the default value for Channel that you should remove the "Channel=" parameter from your url entirely. Have you tried that?

Re: Ignore parameter value if its all selected for URL filtering on report server

Anonymous — Mon, 11 May 2020 06:46:20 GMT

Yes it works that way however I wanted to have a scenario where the dax would be dynamic to accomodate joining URL strings to either IF and Swtich. "&Channel=" so this syntax could be included if channel dax selected value = true then exclude or include. Unless there is a better way? But I struggle with concatenating multiple scenarios and it doesnt seem to work correctly for 5 parameters

Re: Ignore parameter value if its all selected for URL filtering on report server

d_gosbell — Mon, 11 May 2020 23:53:40 GMT

It's hard to say what is going wrong without being able to see your DAX code, but I can't think of any reason why the number of parameters would matter. I think you would just need to have a series of 5 IF blocks to dynamically build up the link.

If you could post your DAX expression and explain any errors or scenarios where it is not working we can probably help fix it.