Single Slicer for Two Columns

[swwong1]

Hi All

Just wondering if its possible to have a single slicer to control two related columns (where one project can be worked on by multiple regions)? In my example below, if I select USA, I would like to see project ABC; if i select Asia, I should also see project ABC. I was thinking I will need a helper column??

** I shared my excel file as I couldn't show my ideal result in PBI.

https://www.dropbox.com/s/4wkiruf83mmahz3/Multiple%20Slicer.xlsx?dl=0 

Many thanks!

 

[swwong1 · Accepted solution]

Thanks @amitchandak @Greg_Deckler 

Thinking this carefully, I have overcomplicated my situation. My example have slightly changed now and all the columns are text based instead of numbers.

Since a PivotTable/Matrix summarises table, any rows with duplicate will only show up once (if I have multiple regions, it will show up in 2 lines in the data but only once in the matrix as I am not showing the region column in the matrix).

[amitchandak]

@swwong1 , with an independent  table in slicer you can do that

A measure like this, here client table is not joined with table

calculate(sum(Table[client]), filter(Table, Table[region] in values(clinet[client]) || Table[region1] in values(clinet[client]) ))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

[Greg_Deckler]

@swwong1 Depends on other things, but often the solution to problems like this is unpivoting your Region columns so that you end up with a single column.