Pie Chart Sort Column

[JillHenninger]

Hi all

I'm building out a dashboard, and am having trouble getting my two pie charts to sort the same way. I've dummied up some data below to illustrate my point. I have two buckets of data - accounts, and competition accounts. There's a filter so you select Account A, and it brings it the right Competition on the other pie. But - i want to sort the Competition Pie by the Account dollars. Is that possible? In Excel, I'd build a pivot of all this stuff, then do a vlookup and voila. But I don't know how to do the sort-by from a different table. I want Brand 1 to be the same color on both as it will make for a better end user experience.

Thanks!
Jill

Problematic View:

 

What I'd do In Excel (yay same order):

[v-diye-msft · Accepted solution]

Hi @JillHenninger ,

Set the relationship and then create the visual:

Pbix attached: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EYlAd8Wtyk1Njv6PAtfl06...

[Anonymous]

@JillHenninger 

I haven't actually tried this with your data given, but if you're trying to sort a pie chart by account dollars, try dragging the account dollars column from the Fields tab into the Filters part of your visualization (in visual level filters). Then, click the elipses in the top right corner of your pie chart and go to Sort by --> account dollars.

Does that work?