Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to Solution.
@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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
110 | |
109 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |