Summing values into one row for specific values selected in slicer

Question

Hello everyone-&nbsp;I have a report with a slicer and corresponding table. There are 3 potential options for the slicer. Say the options for the slicer are: 1, 2 and 3.&nbsp; When slicer 1 and 2 are selected, I want to see the sum of both of them together on one line in my table. However, when slicer 1 and 3 are selected (or slicer 2 and 3), I want to see the results on separate lines. I only want the values to sum into 1 row when slicer 1 and 2 are selected. When all 3 slicers are selected, I want to see 2 rows, one row for the sum of slicer 1 and 2 and the other row for the sum of slicer 3.&nbsp;The report is built so that the unique row is by date and slicer. So, if all three of the slicers are selected, the results will show something like the following (not what I want to see):&nbsp;Slicer:&nbsp;&nbsp;select all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;Date:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field a:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field b:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field c:1/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $50,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$75,0001/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;$50,000&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100,000&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $75,000&nbsp;1/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;$75,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;$50,000&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;$100,000&nbsp; &nbsp;&nbsp; &nbsp;2/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$50,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;$75,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100,000&nbsp; &nbsp;&nbsp;2/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100,000&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$50,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$50,000&nbsp;2/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$75,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $75,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$50,000&nbsp;What I want to see is this: (based on the previous example^. Please assume the first 2 rows for each date in the above example are slicers 1 and 2)1/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $150,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $150,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $150,0001/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $75,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $50,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $100,0002/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $150,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $125,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $150,0002/1/2017&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;$75,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $75,000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $50,000&nbsp;&nbsp;Does anyone know if there is a way to do this? Please let me know if additional detail is needed.&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;mw123,
&nbsp;
&gt;&gt;Does anyone know if there is a way to do this? Please let me know if additional detail is needed.&nbsp;
Current power bi don't support use slicer to control summary records.
Maybe you can try to use programming language to achieve this requirement.
&nbsp;
Regards,
Xiaoxin Sheng

mw123 · Answer

Hi Anonymous,&nbsp;Thanks for getting back to me. Do you know how this could be done using a programming language within PowerBI?&nbsp;&nbsp;&nbsp;

anonymous · Answer

HI&nbsp;mw123,
&nbsp;
&gt;&gt;Do you know how this could be done using a programming language within PowerBI?&nbsp;
It is impossible to achieve these effect in power bi. You can use programming language to write a custom form with datagrid control and specific operations when you choose item.
&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Summing values into one row for specific values selected in slicer

3 Replies

Related content

Fabric Notebook ExitValue how to select specific values

Cumulative sum less than selected month

Specific matrix

Sum dynamic parameter fields multiple selected parameter

Calculate sum of specific months