Multiple Slicers for a same column in power bi

[Narukkp]

Hi Team,

I have one column called TraderName in my dataset and now i need the 3 slicers using the the same TraderName. if suppose in slicer 1 if i selected TraderA, in slicer 2 if i selected TraderB, in slicer3 if i selected TraderC then i need to show the TradeA,TradeB,TradeC related data in my Table grid or chart visulazations. 

Could you please let me  know any one is it possible because if i am created the 3 slicers using same column but as per our client they required 3 slicers instead of 1 slicer because they required the sorting order based on slicers on chart. 

[Anonymous · Accepted solution]

@Narukkp 

For your requirement, it is not possible to used 3 slicers on 1 column, so you could create 3 summarize tables, see my sample pbix:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/EczUvYholJRBkdFSER_H...

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Narukkp]

@Anonymous thank you for your reply.But I need to sum of the sales instead of individual sales .

[Anonymous]

@Narukkp 

You can create a measure for the sum with my sample.

Measure = SUM('Table A'[SALES])+SUM('Table B'[SALES])+SUM('Table C'[SALES])

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[amitchandak]

@Narukkp , It depends on usages. If they are part of table, you can use those columns for the slicer.  If you need only for measures not to display different name together you can join with the same dimension and use userelation

example

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Else you might have to create three tables and use. You can use copy table in edit query

[Narukkp]

Hi,

Thank you @amitchandak . I have total only table that contains Trade Name, Date, Sales... But here my question is if i take the 3 slicers using same Trade Name column then how we can select the diffrent values on second & third slicer  because value will be same on slicer 2 & slicer 3 when i am selected the value in Slicer 1. For your reference PFB screens of Default load & selection screen shot.  In second screen shot i reuqired i am able to select the TradeA in slicer1, TradeB in slicer2 & TradeC in slcier3 then finally i need to display these 3 tradenames related data in table grid. 

 

[amitchandak]

@Narukkp , Create three trader tables and do not join them with your table. Now create slicer from them. As they are not joined use them in filter clause of measure using OR to create the required filter

Like

Measure =
var _T1 = maxx(allselected(Trader1),Trader1[Trader1])
var _T2 = maxx(allselected(Trader2),Trader1[Trader2])
var _T3 = maxx(allselected(Trader3),Trader1[Trader3])

return
calculate([mes1], filter(Table,Table[Trader] =_T1 || Table[Trader] =_T2 || Table[Trader] =_T3))