Page 1 of 1

Using a Concatante formula to show the selected filter in text box

Posted: Thu Oct 25, 2018 12:59 pm
by SeanShafiee
Is it possible to use Concatenate to show the selected filter as text, similar to Excel.


Suppose the filter is located in A1 in Excel. And it is selected “Bikes”

Excel formula will be : =Concatenate(“The following table is highlighted ”& A1&”.”)

The outcome should be: The following table is highlighted Bikes.

How we can do that in Power BI?

Re: Using a Concatante formula to show the selected filter in text box

Posted: Thu Oct 25, 2018 6:16 pm
by PhilC

Re: Using a Concatante formula to show the selected filter in text box

Posted: Fri Oct 26, 2018 9:55 pm
by PhilC
Just came across this too:

{L_CODE}{L_COLON} {L_SELECT_ALL_CODE}

Selected = "Selected Product: " & IF(NOT(ISFILTERED(Product[Name])),"All",CONCATENATEX(ALLSELECTED(Product[Name]),Product[Name],","))

Re: Using a Concatante formula to show the selected filter in text box

Posted: Fri Nov 16, 2018 9:14 pm
by Can


Thanks for sharing! I had the same question!