Forum Discussion
Sorting when using calculation groups
Super UserAlexanderNN , Add a YTD measure as tooltip and try to sort on that
amitchandak That would certainly work, but I would rather avoid it if possible. I have all my measures in one measure table and all my Time Intelligence functions in a calculation group and I would not like to introduce any more measures.
But if it isn't any other way I probably will resort to this. I'm wondering if there is any built-in functionality in Power BI to handle sorting when using calculation groups.
This is an easy one to fix. Just like any table in your model you can specify columns to sort by other columns. In this case you merely need to sort your measures by the Ordinal column. Not sure why Microsoft isn't doing this for us, but just go to the table view table tab and click on your calculation group (table) select the first column and then click sort by column and pick the Ordinal column. See attached.
