Forum Discussion
Helper IIISingle Slicer for Two Columns
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!
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).
3 Replies
- Greg_Deckler
Community Champion
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.
- amitchandak
Super User
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
swwong1Thanks 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).
