Slicer for sales manager

[Anonymous]

Hello all,

I have a table of data like this:

CustomerID	Customer Name	Sales
1	Walmart	100,000
2	Winco	102,000
3	Albertsons	99,222
4	Arco	92,002
5	Sams Club	106,150
6	Costco	100,005
7	Burgerville	85,123

What I would like to do is create a slicer to show only data accocited with the Sales manager Bob:

These are the Customers Bob is accociated with (this table is not in Powerbi)

Sales manager	CustomerID	Customer Name
Bob	1	Walmart
Bob	2	Winco
Bob	3	Albertsons
Bob	4	Arco

What I would like is a slicer with two options: 1. Bob 2. All 

this way I can isolate only bobs data. 

What would be the best approach for this?   I can upload the table with bobs data to build the slicer 

Thank you!

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

According to @camargos88  description, I made  a demo you can refer to.

Pbix attached

And could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

Best Regards,
Community Support Team _ Eason

[amitchandak]

Create a table with two values Bob and All. and based on the selection change the measure. Refer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[camargos88]

Hi @Anonymous ,

You can upload both tables and create a relationship between on Customer ID.

After that just change the slicer settings on Selection controls to allow the "Select All" option. Also, if u want to remove whe blank row on the slicer, just filter it on filter visual.

Ricardo