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.
Hello.
I have the SALES TABLE with salespersons column. How do you compare the salesperson's sales with overall sales showing in a grid like below, but with a slicer for to filter each salesperson? Thanks.
SALESPERSON | SPECIFIC SALES | OVERALL COMPANY SALES |
Adam | 2,000 | 25,000 |
Cathy | 1,500 | 25,000 |
Kyle | 3,500 | 25,000 |
Solved! Go to Solution.
Hi @Oros ,
You can create a column by using DIVIDE function to show the specific sales as a percentage of all company sales.
Column = DIVIDE('Table'[SPECIFIC SALES],'Table'[OVERALL COMPANY SALES])
Or you can put "specific sales" and "all company sales" into a clustered column chart and then put "salesperson" into a slicer, then you will visualize how sales of each salesperson compares to all company sales.
If this is not what you need, please describe how you want to compare two columns more clearly and provide the expected output.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Oros ,
You can create a column by using DIVIDE function to show the specific sales as a percentage of all company sales.
Column = DIVIDE('Table'[SPECIFIC SALES],'Table'[OVERALL COMPANY SALES])
Or you can put "specific sales" and "all company sales" into a clustered column chart and then put "salesperson" into a slicer, then you will visualize how sales of each salesperson compares to all company sales.
If this is not what you need, please describe how you want to compare two columns more clearly and provide the expected output.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
148 | |
116 | |
104 | |
89 | |
65 |