Forum Discussion
Day Sort on Bar Chart
The solution was to join the subsequent tables onto the existing tables. The visual required several orgs to sit together in bar chart format. The source data had the orgs on a single spreadsheet. To get the required look, I read in the source file 7 times and shaped and transformed the data. With the first Org I was able to add an index column and sort it. Did the same thing for the subsequent tables but they would not sort on the index column. I then joined the subsequent tables to the original table and used the Day column from the original in all of the bar charts. Not intutive but it worked.
Please see this link on using the Sort By Column feature. If not already, you can add a column that has weekday # for each date (with WEEKDAY() function), and you can use that column as the Sort By Column for the day name column.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
The solution was to join the subsequent tables onto the existing tables. The visual required several orgs to sit together in bar chart format. The source data had the orgs on a single spreadsheet. To get the required look, I read in the source file 7 times and shaped and transformed the data. With the first Org I was able to add an index column and sort it. Did the same thing for the subsequent tables but they would not sort on the index column. I then joined the subsequent tables to the original table and used the Day column from the original in all of the bar charts. Not intutive but it worked.