Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Graph´s order goes off when sorting by accumulated

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.

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

        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.