cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
shaebert Frequent Visitor
Frequent Visitor

Table Slicer Help

Hello, 

 

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

 

 

Screen Shot 2019-05-17 at 8.46.53 AM.png

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:

 

Screen Shot 2019-05-17 at 8.53.38 AM.png

 

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

 

Screen Shot 2019-05-17 at 8.50.52 AM.png

 

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! 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Table Slicer Help

@shaebert - You can create a new Measure:

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

Hope this helps,

Nathan

2 REPLIES 2
Super User
Super User

Re: Table Slicer Help

@shaebert - You can create a new Measure:

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

Hope this helps,

Nathan

Super User
Super User

Re: Table Slicer Help

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 264 members 2,863 guests
Please welcome our newest community members: