Forum Discussion
POWERBI YYMMMM Sorting in Graph
Dear community,
I've encounter error while maintain the current dashboard and it's unable to sort according to YMInt
Here my table
and here my graph look like right now
I've sort and yet unable to view as intended.
Thank you
Hi SyiraSamsudin
Please follow the below steps to get your result.
1. create calculated column in date table
YMInt = 'Table'[Year] * 100 + 'Table'[MonthNumber]
2. Now
Go to Table View > Click YM column (the one used in chart) > Go to Column Tools > Click Sort by Column > Select YMInt
3. Go to the visual > click the three dot (upper right side of the chart) > Sort the axis > click on YMInt|
If this answers your questions, kindly accept it as a solution and give kudos😊.
2 Replies
Hi SyiraSamsudin
Please follow the below steps to get your result.
1. create calculated column in date table
YMInt = 'Table'[Year] * 100 + 'Table'[MonthNumber]
2. Now
Go to Table View > Click YM column (the one used in chart) > Go to Column Tools > Click Sort by Column > Select YMInt
3. Go to the visual > click the three dot (upper right side of the chart) > Sort the axis > click on YMInt|
If this answers your questions, kindly accept it as a solution and give kudos😊.Create a custom sort column.
sort column = 'Table'[Year] & FORMAT('Table'[MonthInt], "00")Then use this column to sort your YYMMM column. Alternatively, in Power Query, add a custom column using M:
Text.From([Year]) & Text.PadStart(Text.From([MonthInt]), 2, "0")Then use this column as the sort-by column for YYMMM in the model. Sort one column by another column in Power BI
