Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/qyl8cx34biv9g00/tes.pbix?dl=0
Regards,
Frank
Hi @Anonymous,
Does that make sense? If so , could you please mark this answer as solution?
Regards,
Frank
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.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/qyl8cx34biv9g00/tes.pbix?dl=0
Regards,
Frank
Hi @Anonymous what's the desired output look like in a a visual, table, ect?
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |