Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ordering the Legend

 

I'd like to order logically: 05, 6-20, 21-50, 50+

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Create this table:

     

    Bin           Sort

    0-5 1
    6-20 2
    21-50 3
    50+ 4

     

    Relate to your other table. Set the Sort By on the Bin column to Sort. Use the Bin column in your legend.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Greg,

      it won't let me create a new table as I'm using direct query. It says I would have to switch to import mode.

       

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        Yeah, you will have to create that table in your source then.