Multiple value parameters

[anirban121]

1. How to set multiple value parameter in Powerbi?

2. Suppose, I have two parameters in my report, one in Country and another is State. If I pass a Particular Value on the Country parameter, then only the state for that country will appear in the State parameter drop down. How can I configure that?

[amitchandak]

@anirban121 , if they're in the same table it should work bt default.

Different table -https://www.youtube.com/watch?v=cyOquvfhzNM

Or try Hierarchical slicer

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/#_Hierarchic...

[anirban121]

I want as a parameter not a slicer. My requirement is when I will open the file it will ask to enter the parameter values. Based upon the selection, my report will generate.

I have created a parameter list but it's not allowing me multiple selection.

Please find the attached.

 

[richbenmintz]

Hi @anirban121,

This Functionality is not supported currently, you could create multiple parametersm however this would only provide you with a fixed number of items a user could choose. The other option is to create a pagainated report, https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-b..., if you have power bi premium.

Thanks,

Richard