Display all values in a textbox as selected in the Listbox

[AB108]

Hi,

I want to display all the values of a listbox in a textbox.

Right now I am using the expression ='Month-'&[Month]  This works only if one month is selected.

If the month listbox selection is-May Feb Dec. I want my textbox to show Month-May,Feb,Dec.

[Raja2022]

Hi, in the text box use the below formula:

='Month - ' & concat(month &',')

Hope this helps.

[AB108]

Hi @Raja2022,

Unfortunately this is repeating the months for a number of time in the text box. Even with no months selected.

[Raja2022]

Hi,

I changed the formula as below:

=if(GetSelectedCount(month) = 1,'Month - ' & month,
if(GetSelectedCount(month) > 1,'Month - ' & concat(month &',')))

I am getting the below output based on the selection:

[AB108]

@Raja2022  Not Sure why is this not working for me.

I am still getting multiple values. Here is my month formula:

Dual(Month(MakeDate(if(MonthNum<=6,[Fiscal Year],[Fiscal Year]-1), MonthNum)), Fiscal_Month_Num) as [Fiscal Month];
If(month(Date) >=10,month(Date)-9,month(Date)+3) as Fiscal_Month_Num,

[Raja2022]

Can you attach your sample dashboard here ? Otherwise try using max() function and see if that helps.

[Scott9733]

Unfortunately this is repeating the months for a number of time in the text box. 

jcpenneykiosk

[AB108]

@Raja2022  Max is not helping either. Any way this can be done using a variable.

[MarcoWedel · Accepted solution]

 ='Month-'&Concat(Distinct Month,',') 

[AB108]

@MarcoWedel  Thanks this works. Is there a way I can sort them on how they appear. Right now its alphabetically.