Reply
Frequent Visitor
Posts: 2
Registered: ‎11-20-2018

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?

Community Support Team
Posts: 4,024
Registered: ‎07-09-2016

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.
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎11-20-2018

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