Forum Discussion
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 is removed but still multiple rows for "Q4"
It makes sense that when the date sort column is added to visual to have more than 1 row because the values are different. I'm not sure why Qtr-Year would cause this. Any insights? I need to use the column to show trending data across different years.
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]
7 Replies
A measure, the rest are calculated columns from the date table.
Can you attach pbix with dummy data to debug this ?
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]
Yes, it is sorted by the Date Sort Column, if not the Qtr-Year column doesn't go chronologically as shown below
