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

Slicer Selection Summing

Teammates!

 

I have been looking for an answer to this question all over. I have a very large data set that rolls up to 5 different Sales Directors. The slicer selections help navigate through all of the pages and visualizations for each Sales Director, but what I need is the ability for the Select All function of the slicer to sum all of their revenues, targets, rankings, basically every measure I have broken out at the SD level I need at a total region level. Can anyone offer any advice?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Slicer Selection Summing

@fjameshagan,

 

The requirement is not very clear. Share a complete exmaple if possible.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#selection-controls-...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
fjameshagan Frequent Visitor
Frequent Visitor

Re: Slicer Selection Summing

Hope this helps. This is the net revenue delivery by one of our Sales Directors. You can see the actual amount, goal amount, and gain or gap. In the second photo you can see I've selected two Sales Directors and instead of summing the two totals together and showing 700 million, it only shows the most recently selected SD's number. Do you know how to fix this? I want to be able to select all SD's and get a total region number.

 power bi1.PNGpowerbi2.PNG

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 329 members 3,573 guests
Please welcome our newest community members: