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 TViljoen ,
Based on your requirements, I firstly create a table.
Then I create a new table.
Table 2 = VALUES('Table'[Name])
Also I create a measure.
Measure =
IF (
SELECTEDVALUE ( 'Table'[Name] ) IN VALUES ( 'Table 2'[Name] ),
BLANK (),
SUM ( 'Table'[Sales] )
)
Finally when we select the Cust we want, the unselected will also be shown.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
This is almost what I need,
The only thing is that, i need to add therse to a line graph where the selected Cust (Values) as well as their name in the legend. And the Rest (Not selected) is grouped together as lets say: "Other" on the graph