Forum Discussion
Ignore parameter value if its all selected for URL filtering on report server
Hi
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
4 Replies
- Greg_Deckler
Community Champion
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 - d_gosbell
Super User
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?
Hi
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
- d_gosbell
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.
