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 ...
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
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