[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
PowerPivot Forum • Using a Concatante formula to show the selected filter in text box
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

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

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