Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Reorganizing the Y axis

Hi everyone,

i have a Stack Bar Chart where i would like to reorganize the Y axis manually if i have to. I want to sort them using Levels.

Having 1st at the bottom and 14th at the top.
Any help is of course much appreciated :)

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    How do i say i love you? :)

     

    Thanks a million for your patience, i've learn more stuff again :)

7 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous

     

    You can add a column in the table where you have 1st FLOOR, 2nd FLOOR, etc. with the numbers specifying the order. Then use the "Sort by column" option in the "Modelling" pane.   

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi AlB,

      i did modify the original dataset to include that integer  value to be able to sort out by Level Numerical Value. 
      How do i use it to sort the Bar chart but still dispalying the Level name in the Y axis?


      I tried adding a new column 

      Column = 'Room - Final - Export PowerBI (2)'[Level Numerical Value from Level]
       
      And used that to Sort by but no avail :(

       
      Thanks for your patience
      • AlB's avatar
        AlB
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Anonymous

        If you share your pbix I'll try to have a look