different filters to different columns

[yogevz]

hi

i want to create list which has couple of measures and couple of filters.

i want to decide which filter will filter which column.

i saw solution for exclude filter - but this is not the case.

the case here, is that every filter can filter several different columns.

[v-jiascu-msft]

Hi @yogevz,

Generally speaking, the filters will filter the whole model along the relationship. What's your scenario?

1. Are the columns in one table? If they are in one table, they will filter each other.

2. Will you put the columns in one visual? If you put them in one visual, they have to affect each other in some way.

3. Can you filter them in a measure or a calculated column by DAX code? Then you can avoid creating slicers or filters.

If you need more help, please share your .pbix file and your ideas.

Best Regards!

Dale

[yogevz]

thanks for your answer.

attach table to demonstrate.

list with 2 periods, and every period has different filter - as i want to compare 2 periods.

 

Date period 1 filter			Date period 2 filter
	period1	period2
product	measure1	measure2	measure1	measure2
Product 1	10	70	80	90
Product 2	20	50	50	80
Product 3	30	30	60	80

[jweinapple]

I have a similar problem. I am trying to have one column of my table filtered for the date range of 9/1/16-3/13/17, and the other column to be filtered for the date range of 9/1/17-3/12/18.

Is there a SWITCH that needs to be involved with a new table to allow SELECTEDVALUE to choose the specific date range for each?