Forum Discussion

CoreyPawlak's avatar
CoreyPawlak
Regular Visitor
9 years ago
Solved

Re-ordering the x-axis values

Hi, I  am creating Power BI reports and would like to re-order the presentation of the x-axis values in a couple of charts. 1) In a chart showing time-to-consume on the x-axis, I have the x-axis val...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You need to use "Sort By Column" in the Modeling tab in the Data Model. So, go to your Data Model, choose your column go to Modeling tab and choose "Sort By Column". In your case, it may make sense to create an Enter Data query and put in your x-axis values along with a "Sort By" column, so something like:

     

    Category,Sort By

    <5 min,1

    5-15 min,2

    15-60 min,3

    >60 min,4

     

    Sort your Category column by "Sort By", relate this table to your fact table. Use this Category field in your visual. That's the gist of it.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

You need to use "Sort By Column" in the Modeling tab in the Data Model. So, go to your Data Model, choose your column go to Modeling tab and choose "Sort By Column". In your case, it may make sense to create an Enter Data query and put in your x-axis values along with a "Sort By" column, so something like:

 

Category,Sort By

<5 min,1

5-15 min,2

15-60 min,3

>60 min,4

 

Sort your Category column by "Sort By", relate this table to your fact table. Use this Category field in your visual. That's the gist of it.

perpor's avatar
perpor
Helper V
8 years ago

Thanks !!!