topic Re: Power BI Report Builder Multiparameter Issue in Report Server

Power BI Report Builder Multiparameter Issue

DylanVelo — Fri, 24 May 2024 18:09:55 GMT

Hi everyone!

Im having troubles with multiparameters.

I need to be able to select all with one button, give the user the select all button enable by default and also be able to select multi-options if the user need it.

I found some tips but doesnt work for everyting. Im using a dax query.

With the next filter it works well if a i want to apply the "All selected" option in the parameter as default, but its is not allowing multiparameter:

FILTER(VALUES(Dates[YYYYMM]), VALUE(@Period)= -1 || Fechas[YYYYMM] = @Period)

I also tried using RSCustomDaxFilter, it works for multi parameter selection, but cant assign an "All selected" option to filter everyting at once as default.

RSCustomDaxFilter(@Period,EqualToCondition,[Dates].[Period],String)

I know that i can use the default values query, but im having issues with it, first is showing a list of all the fields, and i need "All Selected", and second, for some other parameter which i need to work as this one, the default values is not working. It like if nothing was selected.

Any suggestion on how can i do it?

If we can run the dax query with blanks, without selecting anything, instead of using the "All selected" option, is also good.

The idea is that in some reports we have to many parameters and we dont want the end user to select everything if they dont need those parameters.

Thanks!

Re: Power BI Report Builder Multiparameter Issue

Anonymous — Tue, 28 May 2024 09:09:52 GMT

Hi DylanVelo ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Report Builder Multiparameter Issue

DylanVelo — Thu, 30 May 2024 17:25:10 GMT

Hi Anonymous thanks for you answer. Sure!

im using a power bi semantic model, so im using DAX to create my dataset. This is one of my DAX:

EVALUATE

SUMMARIZECOLUMNS(

'Dates'[Date],

'Attendance'[Grade],

'Attendance'[Motive],

'Attendance'[In],

'Attendance'[Out],

'Employees'[CodeName],

RSCustomDaxFilter(@EmployeesCodeName, EqualToCondition, [Employees].[CodeName], String),

"Attendance Mesure", [Attendance Mesure]

)

The problem is with that i need a parameter that allows the end user to have "All selected" as default, so they dont need to go and apply all the filters if they dont need it, in this case is just one, but for other reports i have about 10 parameters.

So instead of having the select all value label, i want to have "All Selected" option enable as default:

Or the other option would be to dont have the need to select something, so the user can run the report withput selecting anything like if the parameter is not requiered, something like optional parameter but also with multiselection enable.

Thanks!