Forum Discussion
Filter visual by two slicers
Hi,
I have two slicers on my report (which are based on the same column in the same table, the column contains only text). I want to use the selection of both of these slicers to filter a visual (more secifically the breakdown of a waterfall chart but I guess that's not relevant here). How could I do that?
After some research, this is my approach so far:
1.) create two copies of the table - both slicers are based on one of the copies, and the copies have no relationships.
2.) write two measures:
measure 1 = ALLSELECTED(CopyTable1[mycolumn])
measure 2 = ALLSELECTED(CopyTable2[mycolumn])
3.) that's where I don't know how to proceed. I think I have to somehow combine these two measures and then filter the visual based on this, correct? Or is my approach completely wrong?
Thanks for any hint!
Anonymous , refer my example to dates, how two independent tables have been used for filter . Here you have to use in clause
calculate(countrows(Table) , filter(table, Table[mycolumn] in ALLSELECTED(CopyTable1[mycolumn]) ))
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
1 Reply
- amitchandak
Super User
Anonymous , refer my example to dates, how two independent tables have been used for filter . Here you have to use in clause
calculate(countrows(Table) , filter(table, Table[mycolumn] in ALLSELECTED(CopyTable1[mycolumn]) ))
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601