Dynamic Grouping of Slicer Values in a Table Visual

[Anonymous]

Hello,

I have a Slicer that selects Product values, to filter a table that aggregates various metrics such as orders. 

Product	Orders
a	2
b	5
c	0
d	7

I would like the slicer selections to be dynamically grouped to yield this following result, is this possible?

Product	Orders
Group	14

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

You can follow the steps in the below screen shot to achieve it:

Measure = "Group"

Best Regards

Rena

[Anonymous]

Hi @v-yiruan-msft 

Thank you! That seems to have worked, but one follow up question. I am grouping on year/month as well, and that grouping has worked fine for my first table visual. However, this second one utilizing the grouping method is now showing dates outside of the selected date range, both prior (dating back to 2014) and into the future. 

The date fields used by both tables are the same, so I'm not sure why this is occurring - would you have an idea?