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

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

MFelix's avatar
MFelix
Super User
8 years ago

Hi steveorme69,

 

I assume that both your table are related by account. You have to do the following measures:

 

Cost = CALCULATE(SUM('SAGE Trans'[Value]); Nominal[Reference] = "Cost")

Income = CALCULATE(SUM('SAGE Trans'[Value]); Nominal[Reference] = "Income")

This will give you the expected result and you can then place them in the bar chart by the order you need.

 

But if you want further details please share your steps.

 

It's not a video it's a gif image I taken it with ScreenToGif and it's really simple to use just select the area press record and save the image, then upload it as a photo in your post.

 

Regards,

MFelix