I have two slicers, SlicerA and SlicerB. These are multi-select slicers.
I am trying to create a dynamic table that shows the values selected in the two slicers.
- For ROW 1, it displays the FIRST selected option in both slicers (if any).
- For ROW 2, it displays the SECOND option selected (if any).
For example, if the following options were selected:
- SlicerA = Option A, Option C, Option D
- SlicerB = Option E
I would like to see this table result as a result:
SelectedValues = VAR SelectedItems = VALUES('TableName'[ColumnName]) RETURN SelectedItems
I understand that I can store the selected VALUES in a variable but cannot work out how to create a UNION of results into a single table with each row in sequential order (by selection).
Any help would be appreciated and thank you for spending your time on my problem.
Thanking you in advance.
You’re retrieving selected values from a slicer and so you need to use a measure. Measures return scalar values and not tables and so you can’t output a table in the form you desire.
The best you can do to simulate the desired behaviour is write two measures as follows:
Measure = CONCATENATEX( VALUES('Table'[Column1]), 'Table'[Column1], UNICHAR(10))
This will still be a scalar but when placed in a table will appear over multiple rows.