Forum Discussion

Sergey1ap's avatar
Sergey1ap
Regular Visitor
3 years ago

Power BI Report Builder parameters

Hi dear community!

I got a Paginated Report with Power BI Dataset as the source.

Inside this dataset i got about 30 fields and i want to use some of them as parameters.

For example: region_name, store, client_type, device_type, transport_company and payment_type.

How can i set the default values of this parameters to "select all" value which contains all values from selected parameter?

like on the pic.

Please help me.

Thanks in advance.

Cascading Parameters

3 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    3 years ago

    You can do this by using a dataset for the allowed values for the parameter, then use the same dataset as the default values for the parameter.