Forum Discussion
Solved
Date Table Sorting and Grouping
I have a standard date table and added columns to display Quarter, Quarter-Year, and then a Date Sort Column with the dax formula: Date Sort Column = 'Date Table'[Year]*12 + 'Date Table'[Month] ...
Is the date sort column used to define a custom sort of this visual?
If so, this implies that the granularity of the visual includes this dimension, even if the sort column is not visible.
Giuseppe
Yes I use the date sort column to sort other columns such as Qtr-Year. With what you are saying, I need a calculated sort column that uses quarter instead of month. That way it will have the same granularity..
(OLD) Date Sort Column ='Date Table'[Year]*12 + 'Date Table'[Month]
A measure, the rest are calculated columns from the date table.
Can you attach pbix with dummy data to debug this ?
