Forum Discussion
Helper IIdifferent filters to different columns
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.
3 Replies
v-jiascu-msftMicrosoft Employee
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
yogevzthanks 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 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?
