Forum Discussion
Date Format
Anonymous
You can add a column to correct the sort order. What we need is the month number like so.
Month Sort = MONTH ( 'ORDER - Jumbo Query'[RDD] )Then you select the [RDD Monat] column and set the sort order to the [Month Sort] column. Here is an example from another project on how to set the sort by column:
Anonymous
You can add a column to correct the sort order. What we need is the month number like so.
Month Sort = MONTH ( 'ORDER - Jumbo Query'[RDD] )Then you select the [RDD Monat] column and set the sort order to the [Month Sort] column. Here is an example from another project on how to set the sort by column:
Thank you jdbuchanan71 . It worked (as you can see in the lower figure in the screenshot)!
How ever, im still wondering if there is no "simplier" way to shorten the month to "MMM" directly in the figure / dashboard, without creating new columns. If its not the case your proposed solution is fine as well.