Custom X Axis Order

[Anonymous]

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]

WRONG order of X AxisWhat the raw data looks like

[Anonymous · Accepted solution]

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