cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sofia_scott Frequent Visitor
Frequent Visitor

Bar Chart Organization

I have 5 different phases of a project and need to organize them 1-5.  It will only allow me to organize them 5-1 and when I click the various options within the ellipse on the top right, it still won't allow me to do that.3.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Bar Chart Organization

OK, if you use a Sort By field it works. See attached.

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


4 REPLIES 4
Super User
Super User

Re: Bar Chart Organization

Generally, if you click the ellipses and choose what to sort by and then perform that exact same action again, choosing the exact same thing to sort by as before, it reverses the direction of the sort from ascending to descending or vice versa. You could alternatively use a Sort By column potentially as well.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
sofia_scott Frequent Visitor
Frequent Visitor

Re: Bar Chart Organization

When I click the options in the ellipse it only goes 5 4 3 2 1 or 4 3 2 1 5.  None of them make it 1 2 3 4 5

joermccartney Frequent Visitor
Frequent Visitor

Re: Bar Chart Organization

You could create a measure for the total amount for each category seperately and then they will show up on the graph in the order you place them in the values section.

 

ex:

 

1-Meetings = calculate(sum(table[cost]), table[phase]="Meetings")

Super User
Super User

Re: Bar Chart Organization

OK, if you use a Sort By field it works. See attached.

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!