Multiple parameter values from the same table

[Anonymous]

Hi all,

I'm creating a report in which I want to the user to manipulate multiple parameters with values -100 through +100. It's 5 parameters in total. When I create a parameter, DAX creates a table for me with the formula GENERATESERIES. If I make a slicer on that column, the option "single value" is available.

If I base all 5 parameters on column1 (which has the single value option), all 5 values are always the same, which is no good. So I need 5 seperate columns to base my 5 slicers on. I have tried to create 4 more calculated columns in the parameter table, but in the slicer I cannot select single value for those.

Is there any way I can avoid having to make 5 separate tables to operate the 5 parameters?

[v-easonf-msft]

Hi , @Anonymous 

I'm afraid  that you have no choice but to create  5 separate tables to operate the 5 parameters.

BTY ,you can consider using "what if parameter" to achieve the same effect.

In addition to creating the parameter, creating a what-if parameter also creates a measure, which you can use to visualize the current value of the what-if parameter. You also  can select the option"add slicer to this page "  to automatically put a slicer with your what-if parameter onto the current report page.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , Not sure I got it

you can use what if, but values will remain constant only in table.