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!