Forum Discussion

steveorme69's avatar
steveorme69
Helper I
8 years ago
Solved

Sort in Bar Chart

Sorry as I'm sure this is a really quick fix but how do you simply change the order of a Bar Chart.   I want to show Income before Costs in a bar chart but Power BI sorts it alphabetically.     ...
Need Help
  • steveorme69's avatar
    steveorme69
    8 years ago

    All working now !

     

    Sorry I'd put cost rather than costs in the formula.

     

    Really appreciate your help..............cheers

MFelix's avatar
MFelix
Super User
8 years ago

Hi steveorme69,

 

If you have the values of Income and Cost in the same column create a measure for each one something like:

 

Cost = CALCULATE ( SUM(Table[Value]); Table[Type] = "Cost")

Income = CALCULATE ( SUM(Table[Value]); Table[Type] = "Income")

Then just add the measure or columns in the order you want in your chart. In the example below I'm using columns but it also works with measures as I said:

 

 

Regards,

MFelix

steveorme69's avatar
steveorme69
Helper I
8 years ago

Hi Felix

 

Thanks for your reply.  The values for income and costs are in the same column. In fact they are across 2 tables, I have a list of the account codes with balances in a table and then another table to determine whether they are income, costs, assets, liabilities or reserves.

 

E.g. table named "SAGE Trans" contains nominal 4000 which has a value £1,000 and table named "Nominal" holds the list of nominal codes e.g. 4000 and the next column holds the reference "Income".

 

The 2 tables are joined but can't get the measure to work across 2 tables.

 

How did you take the screen video and upload ? as I can show the steps I am going through.

 

Steve