Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Custom Sort bar chart

Hello,   I'm new to Power BI and trying  to sort the chart below by the following order: Agree, Strongly Agree, Neither Agree Nor Disagree, Disagree, Strongly Disagree. I have other statements that ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous in Power Query add another field in your table. assuming your existing field is called "Status" and new column is called "Status Order"

     

    if [Status] = "Agree" then 1 else
if [Status] = "Strongly Agree" then 2 else
if [Status] = "Neither Agree Nor Disagree" then 3 else
if [Status] = "Disagree" then 4 else
5

    Close and apply the changes, go to modelling tab, select "status" field and choose sort by column option and select "Status Sort" column.

     

    Your data will sort as per your need.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous in Power Query add another field in your table. assuming your existing field is called "Status" and new column is called "Status Order"

 

if [Status] = "Agree" then 1 else
if [Status] = "Strongly Agree" then 2 else
if [Status] = "Neither Agree Nor Disagree" then 3 else
if [Status] = "Disagree" then 4 else
5

Close and apply the changes, go to modelling tab, select "status" field and choose sort by column option and select "Status Sort" column.

 

Your data will sort as per your need.

saraammain's avatar
saraammain
New Member
3 years ago

Hi, when I do that, I get a circular dependency error when I try to sort. Could that be because I created the new order column in Power BI desktop instead of going to Power Query?