Data Sort

[Anonymous]

Hi All
I have data like
 
Employe
Product
A
ABC
A
PQR
A
STR
B
ABC
B
PQR
B
STR
 
In  this case, Employee will in Slicer and Product wll shown in table. Requirement is that when the user select Emp=A then output should be PQR, STR, ABC... Value Order should be like this.
And, when user select Emp=B then output should be STR, ABC, PQR..... Values should be like this.
 
I need to show the output in table
&nbsp
Please suggest how i can achieve the same

[v-lionel-msft]

Hi @Anonymous ,

If you only have the [Employe] column and the [Product] column, it's impossible to sort the [Product] column.

But if you have a [Index] column like this, you can achieve it:

Index = 
IF(
    [Employe] = "A",
    SWITCH(
        [Product],
        "PQR", 1,
        "STR", 2,
        "ABC", 3
    ),
    IF(
        [Employe] = "B",
        SWITCH(
            [Product],
            "STR", 1,
            "ABC", 2,
            "PQR", 3
        )
    )
) 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Create a new measure using concatenatex

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax

measure = concatenatex(table,table[product])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[Anonymous]

@amitchandak  Thanks for your response. Can you please brief. After use concatenatex function, then how I can get my ouput,

Should I use SortByColumn.. Or how I can use this function

Kind Regards

Ashwani

[amitchandak]

@Anonymous , Is your issue resolved with above solutions?

[Anonymous]

@amitchandak

Actually, i need the sorting on multiple columns. I have created manually columns.

I have created a column manually but not able to sort as its giving error that you have different values.

Is there any way to sort wuth DAX function. Or is there any way to achieve the same

[v-lionel-msft]

Hi @Anonymous ,

"Is there any way to sort wuth DAX function. "

This function does exist, but you want to sort the text columns, which is not possible.

RANKX() 

"Or is there any way to achieve the same "

Only add [Index] column manually.

Add the [Index] column at the end, and then shrink the table to cover it😂.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

I was assuming you need a comma-separated list. So this will give you. You can show it on Card, table.

Once you filter you will only get for that employee. If you need value row-wise, then filter and table display will do.