Forum Discussion
Help with line graph sorting
Finally figured it out. I needed the use the Date entry listed ABOVE the Date Hierarchy instead of the Month field inside of the Date hierarchy itself. Once I did that, Power Bi sorted by month and year properly.
Hi Dan_at_TWE ,
could you tell us a bit more? How many tables are involved? How is the monthly amount calculated? Some example data showing the table structure or some code, if the amount is calculated based on a measure, would be great.
[GL Cash account Name1],[Amount],[Date],[Account type]
[GL Cash account Name2],[Amount],[Date],[Account type]
[GL Cash account Name3],[Amount],[Date],[Account type]
{There are other columns in the table of course that are not involved in the calculation}
Power BI totals up all the Account types of 'Cash' for the given date based on the slicer and calculates the total in a measure.
The toals are right, other than the sort order. Looking into possibly adding a numerical periodID column to use for sorting order. This same sorting irregularity occurs on all line charts that share the same synced slicer.