Forum Discussion

wshalex123's avatar
wshalex123
Helper III
3 years ago

Measure expression

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 

 

 

 

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    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's avatar
      wshalex123
      Helper III
      3 years ago

      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.