cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

Ordering column of duplicates

Hello,

I have 3 columns (levels) and each column has a Order column,i want to sort teh column but  the problem is my columns have duplicates values like that:

 Group Level 1 level 2 level 3 Order 1 Order 2 Order 3 Store A 1a Ax 1 1 2 Store B 1b Bx 3 2 1 Store B 2b By 3 3 3 Store C 1c Cx 2 4 4 Store C 1C Cy 2 4 5 Head A 1a Ax 1 1 1 Head B 1b Bz 2 2 2 Head B 2b Bw 3 3 3

I create duplicates columns, concatenate group and level to remove duplicates values in each column and sort by Orders columns. But with this solution I have to display Group/Level 1 ( Head/A, Head/B, Store/A,Store B,....), Group/Level 2,... and I want to display only the level without .

Do you have any other ideas?

3 REPLIES 3
Helper I

Anyone else have an idea?

Solution Sage

can you not substitute in here 1,2,3 with 4,5,6?

Helper I

If i do this , the same level will have to Order value and it's not gonna working . Example: Lveal 1a will have 1 and 4 as order position power bi won't understand.