Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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.
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.
Hi,
I will defnitely need some data to work with.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |