title: How to sort a bar chart in Microsoft Power BI (Desktop)
body: <p>I am pretty new with Power BI (Desktop) and I have a basic question.  I have searched Power BI books and sites for a solution, but I could not find it so far.</p>
  
  <p>The purpose of my dashboard is to present the result of an employee survey.  There are about 30 questions, with multiple questions going from 1 (strongly disagree) to 5 (strongly agree).  The questions are divided into 5 different sections.  There is a slicer used to select the section under review, and the average of survey responses to each question is then shown on a clustered bar chart, compared to average and other measures like number of respondents.</p>
  
  <p>The issue is that I would like to have the questions appearing on the clustered bar chart <strong>in the same order as in the inquiry</strong>, and I don’t manage to solve this.  Questions are always sorted on my chart either alphabetically, either based on the average response score…  I tried to add an index in the table with the questions, but I can’t figure out how to sort my question on the chart on that index…</p>
  
  <p>Any suggestion appreciated, Thanks</p>
  
  <p>Fred</p>
  
  <p>Complement info after first answer (thanks for your help!).</p>
  
  <p>My model is built in Power BI desktop.  The list of questions, with their index, is in a DIM_table called DIM_Questions list.  The answers to the questions, of which the average value is presented on the chart, are in a FACT_table called FACT_Responses. There is a relation between the two tables with a field called QuestionID</p>
  
  <p>I did the sort in the modelling section of Power BI, but on the DIM_Questions List table.  Could that be the issue?
  <a href="https://i.stack.imgur.com/USbMG.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/USbMG.jpg" alt="Sort in modelling"></a></p>
  
  <p>The result on the chart is still that questions are sorted on alphabetical order.
  <a href="https://i.stack.imgur.com/CsulS.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CsulS.jpg" alt="chart sorted"></a></p>
  
  <p>Thank you for your help!</p>