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

Top 10 by Revenue for Each Respective Axis Category

I have a stacked column chart to show revenue for each sales manager. The revenue columns are split by customer. How do I display the top 10 customers by revenue for each manager on the axis? I would like 10 companies' revenue for each sales manager column on my chart. All I have, so far, is the top 10 customers by revenue NOT per manager (10 companies total, split across the managers)

 

My fields are: accounts[Customer Name], opportunities[Revenue], and systemusers[Full Name]

 

Edit: A customer only one has sales manager assigned, so there should be 10 unique customers per sales manager.

4 REPLIES 4
Super User
Super User

Re: Top 10 by Revenue for Each Respective Axis Category

Hi,

 

Share some data and show the expected result.  For now, do not both about the visual.  Let's just compute the correct numbers in a simple Table visual first.  Once we have that in place, we should be able to build any chart.

MitchC3 Frequent Visitor
Frequent Visitor

Re: Top 10 by Revenue for Each Respective Axis Category

Capture1.PNG

This is essentially what I am after, but the revenues are sums from the opportunities table relating to a company and each company has a sales manager assigned to it. Can't post actual data due to amount + sensitivity.

MitchC3 Frequent Visitor
Frequent Visitor

Re: Top 10 by Revenue for Each Respective Axis Category

The current workaround I have is a Top 10 filter for company by revenue and then a slicer to filter managers. This way has a default view of total 10 companies and if you want to see one manager's top 10, then you simply select them on the slicer. I would love to show each manager's top 10 at once, but this will work for now.

Super User
Super User

Re: Top 10 by Revenue for Each Respective Axis Category

Hi,

 

I will defnitely need some data to work with.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 40 members 1,099 guests
Please welcome our newest community members: