Forum Discussion
Solved
Dynamic Grouping based on a slicer
Hi There I have a slicer with the Customer Name and then a Values Column Based on the Sales Value of each customer. What I want to do is select a few Customers from a slicer and then Their Sa...
Hi,
PBI file attached.
Hope this helps.
Hi Ashish_Mathur,
Thank you for the solution, I would like to ask if it is possible to achieve the other way round?
I want to group the selected values from the slicers as "others" while the unselected will be shown as is instead.
Desired output:
1. select cust1 and cust2 from slicer
2. In table visual cust1 and cust2 grouped as "other", and cust3 and cust4 show individually
| Customer | value |
| other (cust1+cust2) | 300 (100+200) |
| cust3 | 200 |
| cust4 | 300 |
Thank you.
Regards,
Ronald
You are welcome. I am not sure. Furthermore, i cannot understand the business sense in doing so.