Forum Discussion

DylanVelo's avatar
DylanVelo
Regular Visitor
2 years ago

Power BI Report Builder Multiparameter Issue

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-opti...
"power bi report builder"
multiple parameters
DylanVelo's avatar
DylanVelo
Regular Visitor
2 years ago

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!