Forum Discussion

SyiraSamsudin's avatar
SyiraSamsudin
New Member
5 months ago
Solved

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   ...
Need Help
Tips and Tricks
Tutorial Requests
  • mdaatifraza5556's avatar
    mdaatifraza5556
    5 months ago

    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😊.






     

     

mdaatifraza5556's avatar
mdaatifraza5556
Super User
5 months ago

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😊.