cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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.

 

 


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

View solution in original post

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.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Anonymous
Not applicable

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.

 

 


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 306 members 3,075 guests
Please welcome our newest community members: