Measure expression

[wshalex123]

Hi,

i got a calculated table which shows the next jubilees of my employees:

When creating a table visual it looks like this:

• Note: I created seperate columns for the strings like "feiert in" & "das"

... iam not quite happy with the order of the values in a table visual. Thats why i tried a different solution via a multi card visual.

The measure works, if there is one entry in my table, but it doesnt show multiple hierarchizesed entries in the multi card visual (two or more).

Pictures of the working multi card visual with one entry:

Pictures of the not working multi card visual with multiple entries:

Iam pretty that i have to choose a different formula then SELECTEDVALUE() in my measure to get the visual working.

Maybe someone can help!

Thanks a lot 

[Greg_Deckler]

@wshalex123 What are you not happy with in terms of the order in the table visual? You can change the sorting using the ellipses and you can use Sort By columns as well to modify the order.

[wshalex123]

Hi Greg,

the order of the columns is correct and i know how to sort them of course.

I just want the result to be a "whole" sentence with the same space between all values.

[Greg_Deckler]

@wshalex123 CONCATENATEX

[wshalex123]

@Greg_Deckler 

I tried to change it to your suggested formula. When leaving the "order by expression" gone, i shows me a whole sentence of both entries combined.

I would like to have both entries in different rows. i tried it with the "order by expression" but it shows me following error:

[Greg_Deckler]

@wshalex123 OK, I am confused. First you want a whole sentence and now you don't. Mabye try using UNICHAR(10) as your seperator so that you get a line break?