Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 possi...
Need Help
  • v-xuding-msft's avatar
    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.

     

     

tex628's avatar
tex628
Icon for Community Champion rankCommunity 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's avatar
    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's avatar
      tex628
      Icon for Community Champion rankCommunity Champion
      6 years ago

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

      /J

    • v-xuding-msft's avatar
      v-xuding-msft
      Icon for Community Support rankCommunity Support
      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.