Filering using 2 slicers on same column without any dependancy

Question

Hello All,&nbsp;Thanks for reading my query. I have a requirement where I have two slicer for the same column. For ex, take the below data&nbsp;I need two slicers on Zip column say Start zip and End Zip. When I select 60001 in slicer1 and 60005 in slicer2, I should get the result as60001&nbsp;&nbsp; 160005&nbsp;&nbsp; 2&nbsp;The Problem here is when i select 60001 in slicer1 the data gets filtered for that and when i further select 60005 in slicer2 there is no data as i already filtered for 60001.I tried all the possibilities that i can but nothing helped. Please let me know if this can be accomplished using dax or any other solution.&nbsp;Please share all your suggestions. Thanks in advance.&nbsp;-Nith&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous,&nbsp;You can duplicate the column and turn into number that column, when you put it on a slicer it will be like a date filtering, you select between and can select the beginning and the end.&nbsp;Let me know if it helped, if so mark as solution.&nbsp;BR,DR

anonymous · Answer

Thanks for your response. That solution will return the result as range as in from 60001 to 60005 but i want only those 2.

anonymous · Answer

Alright I think I've figured what you're aiming.

You have to make two diferent tables for that, can't filter from the same since the data in your table must have two columns, one for the Departure ZIP and other for the Destination Zip am I right?

BR,

DR

anonymous · Answer

Exactly that is what i'm looking for. I created two tables for slicer with all the values but couldn't filter as expected.I don't want to duplicate the entire table as it has large volume of data.

v-lili6-msft · Answer

hi&nbsp;Anonymous&nbsp;
If so, you could try this way:
Step1:
You should use two&nbsp;separate dim zip table for two slicers
use these two formula create the dim zip table and don't create any relationshop.
For slicer1 = VALUES('Table'[ZIP])

For slicer2 = VALUES('Table'[ZIP])

Step2:
Then use this formula to create a measure
Measure = var _selectedzips=UNION(VALUES('For slicer1'[ZIP]),VALUES('For slicer2'[ZIP])) return
CALCULATE(SUM('Table'[Optimized value]),FILTER('Table','Table'[ZIP] in _selectedzips
))
Step3:
When create visuals, use this measure instead of [Optimized value]
Result:

and here is sample pbix file, please try it.
&nbsp;
Regards,
Lin

Forum Discussion

Filering using 2 slicers on same column without any dependancy

5 Replies

Related content

dependent slicers

Dependent Filters and Filter Depend on Slicer

Filer list of values in slicer

measure filer issue

Circular dependency