Mutiple selection for different categories - Need help

[Anonymous]

Hi All,

I have got a requirement where I need to apply % change for commision charged that can vary for different transactions.

For e.g I will have two slicer 

A)  % change slicer - with values 0,0.5,1.0,1.5,2.0 

B)  Transaction Type - A, B, C, D, E, F and etc

User can select multiple transaction type and apply % change to see how much he/she is charged. I have achieved this for multiple transaction type and one % change value at a time.

should be able to select A,B and apply % change 'X.X' at the same time user can select C, D and apply % change 'Y.Y'. Can this be achieved? All four transacation type should be displayed in the list as well.

Any ideas on this?

Thanks!

[v-xicai]

Hi @Anonymous ,

>>should be able to select A,B and apply % change 'X.X' at the same time user can select C, D and apply % change 'Y.Y'. Can this be achieved? All four transacation type should be displayed in the list as well.

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

To multi-select data points in visuals, simply use CTRL+Click to select multiple data points. 

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-xicai ,

What I am looking for is to implement below functionality

Filters:

% change slicer                      Transaction Type(multi-select)

0                                             A

0.5                                          B

1.0                                          C

1.5                                          D

2.0                                          E

My user selects B,C and in % change filter he/she selects 0.5, then my table should display,

B                              Amount*0.5

C                              Amount*0.5

with these above options set as selected,my user then selects A and in % chnage filter he/she selects 1.5 then my same table should display all three row for A, B, C with respective % change selected

B                              Amount*0.5

C                              Amount*0.5

A                             Amount * 1.5

Hope I am able to clear my req.

Thanks!