Forum Discussion
Sorting graph based on day week.
Hey everyone,
I’ve got this calendar table that I built with DAX. I’ve been tweaking it as I need more time-based features.
As you can see, I have sort the table by FiscalMonth,
because I need it for this graph:
But now I need add this graph
and I cannot find the way to sort it by Day of the week.
Unsure if I change the sort by column to fix this I will get damage the previous one.
Any ideas?
Thank you,
Hi,
In your Date table, you could create another column and use the SWITCH function to give the days of the week a number. Then use that column to sort the chart.
If this answered your question then please mark it as the solution so others can see it.
Best,
1 Reply
Hi,
In your Date table, you could create another column and use the SWITCH function to give the days of the week a number. Then use that column to sort the chart.
If this answered your question then please mark it as the solution so others can see it.
Best,