Forum Discussion
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 slicer selection.
Please help on this.... Thanks in Advance.....
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
7 Replies
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 ShengHi 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....
venug20 Please remove "Market" field from the second visual, then the counts will match as expected.
venug20 Just want to understand, what is the scenario or reason behind to use the Slicer as an exclusion criteria.
