Graph´s order goes off when sorting by accumulated

[Anonymous]

Hi, i currently have displayed in a graph an accumulated amount of debt over months. However, these months come from a DATEDIFF measure, transformed then into months with a chain of IFs and ordered by custom columns.

The thing is that if i want to see the accumulated debt correctly, (added "month" by "month"), i must order the graph by its measure, but this setting makes the "months" appeared unsorted. 

I want to see the accumulated debt correctly with the "Months" sorted, is that possible?

Thanks in advance.

[amitchandak]

@Anonymous , Not very clear, but seem like you need a sort column

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

I´m already doing that. The months are ordered by a custom sorting column (displaying the month and its order in the next column). That way the months get ordered correctly. However, as soon as i order by cummulated debt to see it correctly, that month order dissapears.

[Anonymous]

Hi @Anonymous ,

According to your statement, I am confused about your sort logic. Do you want to sort your  visual by two columns? Power BI only support us to sort visual by one column. If you sort your table by "Month", you couldn't sort it by "%GT accumulated debt ". If you sort visual by "%GT accumulated debt " the month sort will disappear.

Could you explain more about your sort logic or share a sample file with us ? And you can show us a screenshot with the result you want.

Best Regards,
Rico Zhou

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