Forum Discussion

venug20's avatar
venug20
Resolver I
7 years ago
Solved

Display state wise sales - exclude slicer selection

Hi everyone,   I have one table.    I want to display "sales", based on Slicer selection.   I have taken "State" into slicer. When choose state in slicer, show all state wise sales, except slic...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi venug20,

     

    Normal slicer not support exclude filter affect, you need to do some custom steps with a measure as filter to achieve this effect.
    Please take a look at attachment files if it works on your side.

     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi venug20,

 

Normal slicer not support exclude filter affect, you need to do some custom steps with a measure as filter to achieve this effect.
Please take a look at attachment files if it works on your side.

 

Regards,
Xiaoxin Sheng

venug20's avatar
venug20
Resolver I
7 years ago

Hi Anonymous / Xiaoxin Sheng,

 

Thank you very much for your reply. It's really great work. I am really apriciate your efforts.

 

Please let me explain, what i am expecting output. Please see below snapshots...

 

When i take "State" wise sales into visual, it show like below... (Total is : 1,37,15,444.31)

 

 

 

when i exclude state as "Abia" using basic filter (Visual level), it show like below... (Total is : 1,37,14,380.19)

 

 

You provided file shown state wise sales, when i exclude state as "Abia" from slicer. it show like below... (Total is : 9,08,620.78)

 

 

here some state sales are missing, your approch is 100% correct.

 

but State wise sales total giving wrong. Please suggest to is there any way to get correct output....

 

Please help on this requirement..... 

 

Once again thank you for your reply....

 

 

 

 

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    venug20 Please remove "Market" field from the second visual, then the counts will match as expected.

    • venug20's avatar
      venug20
      Resolver I
      7 years ago

      Thanks Anonymous it is working fine...

       

      Thanks PattemManohar. you suggestion is perfect...

       

       

      Anonymous

       

      Can you explain step by step, how it's working...

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi venug20,

         

        Selector table is used to be the source of slicer, that you can use 'allselected' function to get selected items from slicer.

         

        Selectedvalue function is used to get current row content, then you can compare selected items and current row content to return tag Y if current row are in selected items.

         

        Drag this measure to visual level filter and keep 'N' tag records which means not include in selected items.

         

        Notice: please not create relationship from selected table to original table, it will keep slicer operation only works on measure and not filter on original table.

        Reference links:

        SELECTEDVALUE Function

        ALLSELECTED Function (DAX)

         

        Regards,

        Xiaoxin Sheng