Forum Discussion

AVZ's avatar
AVZ
Frequent Visitor
8 years ago
Solved

Re-ordering the x-axis values

 

In the first Chart im trying to order it by ascending, starting with 0-1 ending with >5.

For the second chart I want to order days starting with monday ending with friday.

Any help would be greatly appreciated!

Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous AVZ 

       

      What if I don't want to use a numeric value or a text field for the sort order?  I have a requirement to sort by a process step, e.g. cut, paint, quality control, ship.  I will have a certain number of works orders in each step.  I want to show that on a bar chart.  The chart will immediately draw attention to any step where works orders are backlogged. 

       

      Neither the number of orders in a step nor the alphabetic sort or of the step name is suitable for sorting the bar chart in the chronological sequence of process steps.

      • tushartechlab's avatar
        tushartechlab
        Advocate II
        6 years ago

        Hey Anonymous 

         

        In this case what you can do is, put the set of process in a table and order them by a key. Then in Power BI take this key as well as a field. Click on the column that you want ordered in graph -> go to modelling tab -> go to sort by column -> select the key column that you used in database for ordering. 

         

        And you are done.

         

        Let me know if the doubt exists.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for sharing correct solution.

  • dhaval0011's avatar
    dhaval0011
    New Member
    3 years ago

    This bug still persists.

    Ideally, it should function at least in simplest form, i.e. how data is provided it should plot it on chart.

    In my table, WK 1 is first and WK 8 is last. In one line chart, it takes correct order from WK 1 to WK 8. But in another one, it starts with WK 7 and jumbles futher.

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi AVZ,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale