Forum Discussion

mkavcic's avatar
mkavcic
Frequent Visitor
4 years ago
Solved

Paginated report - optional parameter

Hi,   In paginated report, I would like to check if nothing is selected in the parameter, then this parameter would not be used in the dax query.   How can I achieve this?   For example, I hav...
Need Help
Show and Tell
Tips and Tricks
  • mkavcic's avatar
    mkavcic
    4 years ago

    Hi,

    Thank you for your answer!

     

    I did solve it in this way:

    1. Add a 'dummy' item called 'All' to the list of items in parameter query.

    2. Make the new item 'All' defualt. You could also use 'Null' here.

    3. Modified the DAX query in VBA with query.commandtext where I entered the command IIF(Parameter.Value = "All", "", "__Usefilter"), meaning if there is 'All' selected then do not use the filter, but if one item is selected then use the filter.

     

    Hope it helps.

    Thank you!

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi mkavcic ,

The easiest way to make a parameter optional is to set a default value for the parameter.

Power BI – Report Builder using Multi Value Parameters in DAX 

  • Create a Data Set with the SLICER value in PBI Desktop
  • Copy the PBI Query. Run the Performance Analyzer in PBI Desktop
  • Create new Parameter referencing to the Main Data Set Query Filter
  • Add a Parameter in the Main Sales Data Set

 

I have also found a similiar post, please refer to it to see if it helps you.

DAX for PowerBI Paginated Report - Multiple Values Selected 

  • you have to use RSCUSTOMDAXFILTER function for multiple values in your Power BI Report builder DAX expression. 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.