Forum Discussion
Sort by column does nothing
Try clicking the ellipses in the visual and changing the sort to the Date column? Is your Sort By on the Date column or the Special Axis column?
By ellipses in the visual you mean the three small dots in the upper right corner of the visual? If so there is not the option sort by date, only be special axis or Value.
Regarding the second question this is where I get a bit confused. If marking the column Date in the date table on the right and then select Sort By Column it shows a tick next to Date (default). See below:
If marking the column special_axis in the date table on the right and then select Sort By Column it is a tick next to axis_special (default). The same goes for when marking sort_column(order_column). But nothing happens with the visual.
I have also tried to add the Date-column and the order column to the visual´s axis cell, below the axis special. But this doesn´t change anything.
Hi Anonymous,
In your scenario, you should firstly select [special_axis] column, and sort [special_axis] column by [sort_column]. Then it should work as expected like below.
However, as both [special_axis] column and [sort_column] are created with DAX and rely on [Date] column, you'll receive an circle dependency error when trying sorting [special_axis] column by [sort_column]. So you'll need to create the two columns in Query Editor with M. :smileyhappy:
Regards
