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

Brian_M's avatar
Brian_M
Continued Contributor
8 years ago

Hi MFelix, could you share how do you make a screen gif like that?

 

It's really useful when trying to show a set of steps on screen!