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 b...
Need Help
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.