Forum Discussion

ChrisDg's avatar
ChrisDg
Helper I
4 years ago
Solved

Sorting by number ranges

Hi,   I'm new to Power BI and I'm having issues sorting my x-axis for my column chart. This is the formula I used to get my index:    Index = SWITCH (     'Company size_Report'[Company size],...
Need Help
  • ChrisDg's avatar
    ChrisDg
    4 years ago

    Hi Winniz,

     

    I figured this out on Friday. Thank you for your response! I did the same thing. However, I will add that this solution won't be resolved unless you also drag the Index column into the Tooltips bar: 

     

     

     

    Thank you,

     

    Chris 

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi ChrisDg ,

 

First add the index column in the Power Query Editor, and then sort the [Company size] column by the Index column. Note that the index column needs to correspond to the value of [Company size] one by one.

 

Sort one column by another column in Power BI 

 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • ChrisDg's avatar
    ChrisDg
    Helper I
    4 years ago

    Hi Winniz,

     

    I figured this out on Friday. Thank you for your response! I did the same thing. However, I will add that this solution won't be resolved unless you also drag the Index column into the Tooltips bar: 

     

     

     

    Thank you,

     

    Chris