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.
Have a scenario where we want to display two different columns on same bar graph:
One column has Sales Rep and the other column has Sales Manager.
We want to see on the same bar graph both Sales Rep and Sales Manager with the sales total.
Fact table which has sales total is joined to the dimension table (which has sales rep and sales manager) through sales rep ID.
Just doing a side by side comparison on the same graph
Solved! Go to Solution.
Ok so let me clarify:
A Sales Rep has sales and manager.
A Sales Rep's sales are his sales only.
A Sales Manager is his sales plus the sales of any Sales Rep below him. Is that correct?
If thats the case, you'd need to create a measure that does 2 sums and adds them together. The first sum would simply be "Sales with my name on it" and the second would be "Sales where I'm the manager".
Now Sales Reps will always be 0 for that second one, so it should work fine. Sales Managers who don't actually sell will be 0 for the first one. Overall you should get the right number and you can then place this onto the same Axis. The only thing you'll need is a list of Employees to act as your Axis.
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.