Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Order of Chart

Hello - 

 

I have a chart that shows hours (y axis) by days (x axis). I am using a stacked bar chart, where the hours are split by "before", "after", and "during". 

 

Right now, the chart organizes the information by - after, before, during. I would prefer the order to be before, during, after. 

 

What's the easiest way to do this? 

 

Thanks,

M

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Locate to Query Editor mode, add a conditional column.

     

    In report view mode, choose the field that should be added to legend, change its sort by setting from default to "Order" column.

     

    Result.

     

    Best regards,

    Yuliana Gu

2 Replies

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    8 years ago
    You could do a conditional If statement in the query window to add a numerical value. Before 1, During 2, After 3. Then sort it by the number. Either that or use the Switch function to do something similar.

    D
  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    Locate to Query Editor mode, add a conditional column.

     

    In report view mode, choose the field that should be added to legend, change its sort by setting from default to "Order" column.

     

    Result.

     

    Best regards,

    Yuliana Gu