Sorting graph based on day week.

[ajdm2007]

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, 

[MNedix · Accepted solution]

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,