Dynamic generation of slicers - multiplying multiple rows, each by a unique (user selected) value

[davidz106]

Is there a way to allow users to select a value (between 50 and 150) for each Trial_label and then multiply each corresponding row in the dataset by the selected value? The number of Trial_labels is variable, ranging from 1 to 15, and each Trial has a unique name.

[Anonymous]

Hi, @davidz106 

Thanks for @MattAllington help. Feel free to help if you can share some sample data without sensitive information and expected output.

Best Regards,
Yang
Community Support Team

[MattAllington]

You can filter any values you don't want in the filter pane. You could also produce your own disconnected table by importing values you need and paste into a new table in PBI. 

[MattAllington]

Yes. Create a numeric field parameter. This generates a disconnected table in the model. The value measure can be used inside another measure to do the calc you need. You can also use the column in the disconnected table in the visual (instead of the slicer) to show all possible outcomes. 

[davidz106]

I want to multiply each row by different user selected value (different for each Trial_label/row). As far as I understand numeric field paramter will only be 1 value by which I could set up multiplication. Probably this is not achiable in PBI since I would need modifyable datatable.