Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Concatenatx

Hi Guys,

 

May I ask what is the problem with my dax expression? I want to concatenate "next new line" every after selected values on the parameter.

 

Here's the expression:

 

SelectedEmp = IF(
ISFILTERED(TrackingTicket[employee]),
SELECTEDVALUE(TrackingTicket[employee],
CONCATENATEX(VALUES(TrackingTicket[employee]), TrackingTicket[employee], & UNICHAR(10))
), "All Employees"
)

 

 

Thank you

 

Arvin

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @Anonymous,

 

Based on my test, we can update your formula like this:

 

Measure = IF(ISFILTERED(TrackingTicket[employee]),CONCATENATEX(ALLSELECTED(TrackingTicket[employee]),TrackingTicket[employee]& UNICHAR(10)),"All Employee")

 

Then we can get the result as below.

 

Capture.PNG

 

For more details, please check the pbix as attached.

 

https://www.dropbox.com/s/qyl8cx34biv9g00/tes.pbix?dl=0

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

4 REPLIES 4
v-frfei-msft
Community Support
Community Support

Hi @Anonymous,

 

Does that make sense? If so , could you please mark this answer as solution?

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
v-frfei-msft
Community Support
Community Support

Hi @Anonymous,

 

Based on my test, we can update your formula like this:

 

Measure = IF(ISFILTERED(TrackingTicket[employee]),CONCATENATEX(ALLSELECTED(TrackingTicket[employee]),TrackingTicket[employee]& UNICHAR(10)),"All Employee")

 

Then we can get the result as below.

 

Capture.PNG

 

For more details, please check the pbix as attached.

 

https://www.dropbox.com/s/qyl8cx34biv9g00/tes.pbix?dl=0

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
dtartaglia
Resolver I
Resolver I

Hi @Anonymous what's the desired output look like in a a visual, table, ect?

 

Anonymous
Not applicable

Hi @dtartaglia thank you for taking time responding on my inquiry. The desired output look like is this:

 

When nothing is selected on the Parameter/Filter, it will shows on the CARD, "All Employees". 

When one is selected, it will shows, "Employee 1".

When multiple are selected, it will shows,

 

Employee 1,

Employee 2,

Employee 3

 

something like this.

 

Is this possible?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.