Merge multiple selected slicer items in a string

[HansZuijd]

Hi,

i've created the below slicer and want to display the selected items on a card. the output should look something like "2017 (Q3, Q4), 2018, 2019, 2020 (Q1)"

any ideas on how to realise this?

kind regards, 

Hans

[johnt75 · Accepted solution]

Try

Selected Quarters
VAR SummaryTable =
	SUMMARIZE( 'Date', 'Date'[Year], 'Date'[Quarter] )
Var Txt = CONCATENATEX( VALUES('Date'[Year]),
	VAR Yr = 'Date'[Year]
	VAR Qrs = CONCATENATEX(
		FILTER( SummaryTable, 'Date'[Year] = Yr),
		'Date'[Quarter],
		", "
	)
	RETURN Yr & " ( " & Qrs & ")",
	", "
)
RETURN Txt 

[amitchandak]

@HansZuijd , Not exact the same but you can try something like this example

concatenatex(Date, Date[Quarter] & "-" Date[Year], " , " )