Customly sorted x axis in combo chart with cumulative measure need to be fixed

[Henneking]

Hello dear Power BI community

I am relatively new to the Power BI world but have a rather specific issue. I am using a combo chart, first, combining the absolut value in bars and, second, showing the cumulated percentage as line. While creating this chart, I researched how to customly sort my x axis. (Insight: Power Bi use to sort the x axis in order of the first letter show e.g. 0, 1, 10, 2, 20, 3 etc.)

For the cumulative line chart I used a measure which worked just fine untill is customly sorted my bar chart. 

I assume that the line chart still counts according to the default Power BI order meaning 1, 10, 2, 20 instead of in the new order I have created.
Can you assist me one getting my cumulative line chart right? (see below)

[chethan]

@Henneking  Create a New table by Summarising the x-axis data labels with index then build  relationship & sort by x-axis data labels with index it will work

[v-danhe-msft]

Hi @Henneking ,

what is your desired result for your visual? And could you please share your pbix file that I could have a test for you.

Regards,

Daniel He

[Henneking]

Hi! Thanks for your reply @v-danhe-msft 

As far as I think, the running total percentage is based on the category and not on the custom order I applyed. But it needs to cumulate the way I customly changed the x achsis category order. So, in practise I change the order to "1,2,3,4,5,5-10,10<, Error" manually. Power Bi sorted it as 1,10<,2,3,4,5,5-10, Error" automatically. That's (in my asumption) why the line chart is wrong. It is related to the Power Bi internal order instead of my manual order. 

I cannot upload the file to here - sorry. The data is labeled as confidential. But maybe you have a different idea.

[v-danhe-msft]

Hi @Henneking ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Henneking ,

Yes, the order in Power BI with text is by design, if you want to custom order your data, you could refer to below link:

https://community.powerbi.com/t5/Desktop/Custom-Sorting-in-PowerBI/td-p/126534

Regards,

Daniel He