Slicer select all the items

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

Need Help

v-xuding-msft

6 years ago

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.

Slicer select all the items.pbix32 KB

6 Replies

amitchandak
Super User
6 years ago
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
  Not applicable
  6 years ago
  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 ?
tex628
Community Champion
6 years ago
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
  Not applicable
  6 years ago
  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 @
  - tex628
    Community Champion
    6 years ago
    It is, post the measure that you are using in your visual.
    
    /J