Concatenate two fields in a measure

[Jensej]

Hi!

So i have a stacked column chart that shows how many hours an Employee has worked for on different projects.

Axis = EmployeeName

Legend = Project

Value = Hours

Now i want to add Fullname to the Axis and since i have Lastname and Firstname in different columns i wanted to create a simple measure where i concatenate thoose two but i cant do it like this is seems. Im not able too choose thoose fields from the table. What can i do?

= CONCATENATE("NAME"," "+"First Name") 

[AlB · Accepted solution]

Hi @Jensej 

Don't create a measure, create a new calculated column in your table:

NewAxisCol =
Table1[FirstName]  & " "  &  Table1[LastName]

 The use that column in the x axis of the chart

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak · Accepted solution]

@Jensej , You need to create a column, You can not use measure on-axis

example

Full Name= [NAME] & "," & [First Name]

[AlB · Accepted solution]

Hi @Jensej 

Don't create a measure, create a new calculated column in your table:

NewAxisCol =
Table1[FirstName]  & " "  &  Table1[LastName]

 The use that column in the x axis of the chart

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Jensej]

 Thanks! @amitchandak @AlB Thought i could do this with a measure.  I forgot to say Column 1 is text and Column 2 ist number and now when i want to concatenate them i get this error. "Cannot convert value "blabla"  from type text into type number" How can i turn the Number into text?

[AlB]

@Jensej 

It should conver the number to text automatically when applying the & . In any case, try this:

CONVERT(Table1[Column],STRING)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers