Table Slicer Help

[shaebert]

Hello, 

I have a table that I'd like to transform depending on a slicer choice. The table has the following data:

I want to create a visual that displays the data above with a slicer for the Manager. When no specific manager is selected (so ALL) I want the data to appear as this:

Then when I select a manager in a slicer (let's say I pick Joe) I want to show the following. 

I am guessing I have to invoke some type of grouping or splitting function when the slicer changes, but I am not sure and don't know how to do that in Power BI. 

Any help would be appreciated! 

[parry2k]

@shaebert add following measure

Managers = CONCATENATEX( Table4, FIRSTNONBLANK(Table4[Manager],""), "," )

Put table visual and add columns Activity, Managers (new measure), Campaign and Sales in it and you will get the result.

[Anonymous · Accepted solution]

@shaebert - You can create a new Measure:

Managers = CONCATENATEX(VALUES(Table1[Managers]), [Managers],",")

Hope this helps,

Nathan