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

Used for anything related to the new Power BI Desktop and Service tools
SeanShafiee
Posts: 1
Joined: Thu Oct 25, 2018 9:05 am

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

Postby SeanShafiee » Thu Oct 25, 2018 12:59 pm

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?


PhilC
Posts: 161
Joined: Tue Sep 09, 2014 8:13 am

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

Postby PhilC » Fri Oct 26, 2018 9:55 pm

Just came across this too:

Code: Select all

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

Can
Posts: 1
Joined: Fri Nov 16, 2018 9:05 pm
Location: North Berhen,NJ

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

Postby Can » Fri Nov 16, 2018 9:14 pm



Thanks for sharing! I had the same question!


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest

cron