cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mshparber Established Member
Established Member

Re: Pie Chart Order of Slices (NOT accordingly to letters of numbers order)

@germanobasler did you try "Sort by Column" option as I have proposed?

It's exactly what you need.

It doesn't matter that your DB is thousands of rows. As long as you have a limited number of stages.

You should create a StageDim table with few entries as the number of stages.

Then connect it to your DB Fact table

Then, define the Order column it the small dimension table

Then, use "Sort by column" option as I have described previously.

It should easily work

Michael

germanobasler Regular Visitor
Regular Visitor

Re: Pie Chart Order of Slices (NOT accordingly to letters of numbers order)

Dear @mshparber, good afternoon. I tried to proceed as you advised but still didn´t succeed.

 

I am trying to post printscreens, but it won´t let me!

 

I created a new sheet with only two columns (Categories to the left and Order on the right from 1 to 7). And then I sorted column "ascending" from 1 to 7, then the categories appeared in the right way.

 

Sheet uploaded. Then PBI already understood the relation between this sheet and the main database. Link was created automatically in Relationships tab.

 

Then back to Report tab, I replaced in the pie chart the column "Category" from the main database with the brand new created sheet ordered "category". The values to appear in the pie chart I pulled from the main database, as it is linked.

 

Result: Same thing. I must have missed something.

 

 

mshparber Established Member
Established Member

Re: Pie Chart Order of Slices (NOT accordingly to letters of numbers order)

@germanobasler I think You have missed one step:" Sort by column":

Open the new small table (on your left side there are three icons, chose the middle one that looks like a table, then, on your right side click on the new table)

Select the Stage column, then in the upper menu click "Sort by column" and chose the Order column. 

Please see screen shots that I have posted earlier. 

This step tells the system that you want to sort the values in one column "Stage" by the values in another column "Order"

Together with all the rest that you have done it should work

Michael

Highlighted
mshparber Established Member
Established Member

Re: Pie Chart Order of Slices (NOT accordingly to letters of numbers order)

It is important that you use "Sort by column" from the upper menu after you have selected the Category column. From the options you will see, select the Order column. 

 

It is not the same as just ordering a table by a column, it is ordering a column by another column. 

 

Michael

View solution in original post

germanobasler Regular Visitor
Regular Visitor

Re: Pie Chart Order of Slices (NOT accordingly to letters of numbers order)

@mshparber

 

Yes, you got my point and that was precisely what I missed, I missunderstood the steps. 

 

It works! Thank you a lot.

 

Thanks a lot to all folks that answered as well.

 

My best regards,

Germano Basler

mshparber Established Member
Established Member

Re: Pie Chart Order of Slices (NOT accordingly to letters of numbers order)

@germanobasler 

Glad to hear it worked!
May I also suggest that instead of using Pie Charts - try vertical Bar charts or a Tunnel chart.

Usually, it is not quite effective to show information of more than two categories on a Pie chart: it's hard to tell the relativeness of each slice.

Compare for example these three charts showing the same data.

From the Pie chart it is hard to say which category is bigger: Apples or Bananas. As well as Candy vs Drones vs Elephants

Whereas the proportions are very clear on the other two charts.

You can also sort those by the Category.

Good luck!

Michael Shparber

NoPie.JPG

 

 

 

 

germanobasler Regular Visitor
Regular Visitor

Re: Pie Chart Order of Slices (NOT accordingly to letters of numbers order)

Michael, I cannot thank enough. You are absolutely right. 

 

At the end, it was really worthwhile to learn the function "Sort Column", which widened my PBI knowledge! (still a loooong way to go =D )

 

Germano Basler

 

 

mshparber Established Member
Established Member

Re: Pie Chart Order of Slices (NOT accordingly to letters of numbers order)

My pleasure!

Good luck with PBI! It is AWESOME!

Enjoy and someday you will be helping others in this community also!

Cheers,

Michael

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)