Forum Discussion

miguelflores's avatar
miguelflores
Advocate I
9 years ago
Solved

Sorting Data Manually

Hi!   How do I sort a stacked bar chart by age group in ascending order?  From Below 18 Years old to 65+ Years old?   Thanks!
Need Help
Show and Tell
Tips and Tricks
  • Sean's avatar
    Sean
    9 years ago

    miguelflores

    I take it you've created those "Bins" with a conditional column

    I'm calling this column Category in the image below

    Then I use it to create another Column called Custom Sort which we'll use to sort the Bars

    See image below - let me know if you have any questions...

    Hope this helps! :smileyhappy:

     

    EDIT: I've used the Query Editor for both columns

    but you can use SWITCH statements (nested IFs) to get the same results with DAX created columns! :smileyhappy:

miguelflores's avatar
miguelflores
Advocate I
9 years ago

I already tried it but the result looks like this:


 

In my mind it shoutd be:

Below 18 Years Old

18-24 Years Old

25-34 Years Old

35-44 Years Old

45-54 Years Old

55-64 Years Old

65+ Years Old

 

is there a way to manually sort it?

 

Thanks!

Sean's avatar
Sean
Community Champion
9 years ago

miguelflores

I take it you've created those "Bins" with a conditional column

I'm calling this column Category in the image below

Then I use it to create another Column called Custom Sort which we'll use to sort the Bars

See image below - let me know if you have any questions...

Hope this helps! :smileyhappy:

 

EDIT: I've used the Query Editor for both columns

but you can use SWITCH statements (nested IFs) to get the same results with DAX created columns! :smileyhappy:

  • miguelflores's avatar
    miguelflores
    Advocate I
    9 years ago

    Thanks! I got it! :)

     

    What books do you recommend in using the powerbi more effectively and efficiently?