Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Custom X Axis Order

Hello community, 

I have a question on what I assume could be a simple fix.

The project is displaying the results of a survey conducted and linked to a Smartsheet sheet where the forms are entered.

 

The survey answers (and the data being entered) is all "Strongly Agree" ... "Neither Agree/Disagree" ... "Strongly Disagree".

 

Right now the graphs can only do largest to smallest based on COUNT or acending/decending.

 

Is there a way I can set the graphs to be "Strongly Agree" + "Somewhat Agree" + "Neither Agree/Disagree" etc.? 

Right now, the graphs all have the same input for the axis, legend and values (the column of answers for each question, each question has its own column).

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

     

    I'd like to suggest you refer to following blog to create a custom sort table with 'sort by column' property to setting column order:

    Custom Sorting in Power BI

     

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    WRONG order of X AxisWhat the raw data looks like

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous,

       

      I'd like to suggest you refer to following blog to create a custom sort table with 'sort by column' property to setting column order:

      Custom Sorting in Power BI

       

      Regards,

      Xiaoxin Sheng