Change of column sorting

[CJKPowerBI]

Hello all,

i have the below measure

Total per column per year: = sumx(ADDCOLUMNS(SUMMARIZE('Family situation PowerBI','Family situation PowerBI'[Type],'Family situation PowerBI'[Date].[Year]),"@result",[ValueLatestDate(all Years)]),[@result])

which gives me the below results

and i would like to know if i can have the columns Balance and Invested different with Invested to be first and second to be Balance.

than you

[v-jianboli-msft · Accepted solution]

Hi @CJKPowerBI ,

Please try:

Then choose sort by column:

Final output:

Best Regards,

Jianbo Li

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

[CJKPowerBI]

hello @v-jianboli-msft 

i figured out the issue, the issue was that some of my text was:

- Invested

- invested (with not capital I)

and that was giving the error...

that works great,

thank you

[CJKPowerBI]

hello @v-jianboli-msft 

i tried the above and at the pic which i sort i get the below error

[v-jianboli-msft]

Hi @CJKPowerBI ,

Based on your description, I have created a simple sample:

Please try:

Create a sort column:

here is the M code:

= Table.AddColumn(#"Removed Columns", "Sort Column", each if [1] = "Balance" then 2 else 1)

Then sort by column:

Final output:

Best Regards,

Jianbo Li

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

[CJKPowerBI]

Hello @v-jianboli-msft 

i tried to follow your instructions and even look at the .pbix file but unsuccesfully couldnt make it work.

below is part of my data

and if i understood i need to make a column with the formula which you gave me that all no?

can you look at your formula based on my columns above?

thank you