cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

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.

Top Ideas
Users Online
Currently online: 6 members 1,027 guests
Please welcome our newest community members: