Is it possible to create parameter that can select multiple values?

Question

Hi,

I just want to know the possibility of creating something like below in Power BI that I can have the capability to select multiple columns with one parameter. Cause currently in FDI, I need to create parameter for every column that can be selected.

Here's what currently in FDI, my problem is it would not be good if I add more than 5 rows and it's tedious for the users to select for every parameter just to be added in the table. I guess a different approach in the calculation will work?

Gianni Ceresa · Answer

@JobDeLuna , MOS (support.oracle.com) is only accessible to users with a paid support contract. If this isn't your case, then you can't access MOS content (and it can't be posted here publicly because it's a paid-content). If you have a CSI, link it with your Oracle Account to have access to MOS.

JobDeLuna · Answer

Hi, @Nehemias-Oracle , thanks for your response. however the link is redirecting me to this one

Gianni Ceresa · Answer

Hi,

You can easily make your prompt a multi-select, having a single prompt with checkboxes just like your Power BI screenshot.

The challenge is then that you need to have enough placeholder columns in your visualization to handle the various values. It is not possible to have a single calculation handling them all, you will need something like you have now, with a number of calculations handling those values.

The main change is that you need to adjust your expression: a multi-select prompt will contain the values separated by a " , ", therefore your calculation should be adapted to take the value at the n-th position separated by " , ". There are string functions to handle this kind of situation.

The only issue I see is that if you make a prompt multi-select, you can't say that it can only select 3 values (based on your screenshot), therefore it's possible that a user will select more values than you have placeholder columns with a calculation to handle the value. You will need to teach your users how to use it in the best way.