Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

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.