Forum Discussion
Once Slicer for multiple columns
Hi Anonymous,
There is a solution below. Please check out the demo in the attachment.
1. Create a new table as slicer table.
SlicerTable = DISTINCT ( UNION ( VALUES ( Table1[Part One] ), VALUES ( Table1[Part Two] ), VALUES ( Table1[Part Three] ), VALUES ( Table1[Part Four] ), VALUES ( Table1[Part Five] ) ) )2. Rename the column name of the new table. (optional)
3. Do not establish any relationships!
4. Create a measure.
Measure = IF ( MIN ( 'Table1'[Part One] ) IN VALUES ( SlicerTable[values] ) || MIN ( 'Table1'[Part Two] ) IN VALUES ( SlicerTable[values] ) || MIN ( 'Table1'[Part Three] ) IN VALUES ( SlicerTable[values] ) || MIN ( 'Table1'[Part Four] ) IN VALUES ( SlicerTable[values] ) || MIN ( 'Table1'[Part Five] ) IN VALUES ( SlicerTable[values] ), 1, BLANK () )
Best Regards,
Dale
Hi Anonymous,
How will this slicer work?
Why aren't the rows (Name 2, Name 9, Name 11) in the expected result?
Best Regards,
Dale
Hello Dale,
Sorry to the late response, Seems that it did not copy correct!
It should look like this;
Threat Node Activity Part One Part Two Part Three Part Four Part Five Area One Down Name 1 Base Management Production Shop Production Shop Area One Down Name 2 Base Management Production Shop Flow Assurance Production Shop Production Shop Area One Up Name 3 Production Shop Base Management Production Shop Flow Assurance Road Right Name 8 Base Management Production Shop Base Management Corrosion Road Right Name 9 Base Management Gateway Flow Assurance Corrosion Corrosion Upper Deck Right Name 10 Base Management Production Shop Base Management Flow Assurance Upper Deck Right Name 11 Base Management Production Chemist Process Engineer Area Ops Flow Assurance Even if it is not a slicer, can this be done in a table as show with filters?
Hi Anonymous,
There is a solution below. Please check out the demo in the attachment.
1. Create a new table as slicer table.
SlicerTable = DISTINCT ( UNION ( VALUES ( Table1[Part One] ), VALUES ( Table1[Part Two] ), VALUES ( Table1[Part Three] ), VALUES ( Table1[Part Four] ), VALUES ( Table1[Part Five] ) ) )2. Rename the column name of the new table. (optional)
3. Do not establish any relationships!
4. Create a measure.
Measure = IF ( MIN ( 'Table1'[Part One] ) IN VALUES ( SlicerTable[values] ) || MIN ( 'Table1'[Part Two] ) IN VALUES ( SlicerTable[values] ) || MIN ( 'Table1'[Part Three] ) IN VALUES ( SlicerTable[values] ) || MIN ( 'Table1'[Part Four] ) IN VALUES ( SlicerTable[values] ) || MIN ( 'Table1'[Part Five] ) IN VALUES ( SlicerTable[values] ), 1, BLANK () )Best Regards,
Dale