Slicer select all the items

[Anonymous]

I have two items in my slicer checker called - 

1) Suspicious sellers

2) Unauthorised sellers

If I select both 1 and 2, I want to show data for only suspicious even I select all,

Is that possible, can we create a measure or something like that?

Please help me fast as soon as you guys find anything, it's important

Thanks

[tex628]

This depends on how your data looks but you should be able to do something like this. 

Your main table:

Row Number	Seller Type
Row 2	Suspicious Seller
Row 3	Unauthorized Seller
Row 4	Suspicious Seller
Row 5	Suspicious Seller
Row 6	Unauthorized Seller

Create new table:

Key	Seller Filter
-	Unauthorized Seller
Suspicious Seller	Suspicious Seller

When you have created the new table, create a relationship between "Key" and "Seller Type" and finally use "Seller Filter" in a slicer. 

/ J

[Anonymous]

You didn't get my question

If i select suspicious seller then graph will show the count of suspicious seller and when I select unauthorised it show the count fo unauthorised seller.

And when I select both of them then graph will add the count of both suspicious and unauthorised seller, 

but what I want to do is, when I select both of them then graph will show data for suspicious seller, is it possible?

By creating measure or something ?

@amitchandak @tex628 @

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You could follow the steps to have a try:

• Create a table

Slicer = VALUES('Table'[Sellers])

• Create a measure

Measure = 
var Selection = ALLSELECTED(Slicer[Sellers])
var TotalSales = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Sellers] in Selection))
var SuspiciousSellers = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Sellers] = "Suspicious sellers"))
var CountSelection = COUNTROWS(Selection)
return
IF(ISFILTERED(Slicer[Sellers]),IF(CountSelection>1,SuspiciousSellers,TotalSales),0)

For the option of "Select all", we can't get data from it. The result will show 0 (no filter) while using it in my sample. For more detais, please download the attachment below to try.

[tex628]

It is, post the measure that you are using in your visual.

/J

[amitchandak]

@Anonymous , refer how to control measure using slicer

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

You can change measure or calculation based on slicer

[Anonymous]

You didn't get my question

If i select suspicious seller then graph will show the count of suspicious seller and when I select unauthorised it show the count fo unauthorised seller.

And when I select both of them then graph will add the count of both suspicious and unauthorised seller, 

but what I want to do is, when I select both of them then graph will show data for suspicious seller, is it possible?

By creating measure or something ?