Forum Discussion
Single slicer for multiple column multiple categories
Main Table: Customer Type Customer 1 Name Customer 1 BU Customer 2 Name Customer 2 BU Customer 1 Owning User Customer 2 Owning User Customer 1 Created By Customer 2 Created By Conta...
I figured it out. Tweaked the logic mentioned in the https://www.sqlbi.com/articles/creating-a-slicer-that-filters-multiple-columns-in-power-bi/
lbendlin
Super User
Super UserThis is how your main table should look like
I appreciate your time on this.
The way I have shown the main table, that's the ideal behavior of this report. It is to find duplicate customers based on certain conditions.
So customer A & customer A_1 are like victim & survivor respectively. So if I bring them all customers in one column, that would defeat the purpose of this report.