Forum Discussion
Solved
Sort By Column Not Working / Help with Dates Table
I created a Matrix Visualization to display progress over my Agency's fiscal year, which starts in October (seen in the first screenshot). I used a date table (seen in the 2nd screenshot) which I ha...
It looks like your Date, Day, and Quarter columns are DateTime instead of Date. I would change those data types. Also, please see these two articles, that include M and/or DAX code to create Date tables that do not require Sort By Columns and a way to make a fiscal calendar that includes weeks.
No Sort Date Tables! – Hoosier BI
445 Calendar with 53-Week Years – Hoosier BI
Pat
Thank you so much for the resources!