Combine rows when filter selection or value is 'Select all' in the SLICER

[BBIUser]

Hi,

I tried few solutions and showing combined records in a table based on the filter selection for 'Select All' was not possible. Does anyone have a solution? Here is my scenario.

1st screenshot is the records from the existing table visual. NOTE: Sections Column is used only for testing. I have a Section SLICER with "Select all" and other values such as 1 to 5 and 6 to 10.

Expected result (2nd screenshot)

When I select "Select all" it should show the combined results into a single record as shown in 2nd screenshot . But when I select 1 to 5 or 6 to 10, it should show as in 1st screenshot (it should not combine those values).

Appreciate your help. Thanks!

[v-shex-msft · Accepted solution]

Hi @BBIUser,

Current Power BI will automatically summarize them if the fields you selected have the same value.

Accordingly, when you select “Selected all”, it will show the combined results into a single record. (1st screenshot)

However, when you select “1 to 5” or “6 to 10”, it will also show the combined results into a single record. (2nd screenshot)

If you set “Total” field as “Don’t summarize”, it won’t show the combined results into a single record when you select “Selected all” . (3rd screenshot)

In other words, these two conditions can’t be met at the same time, so it is hard to achieve your requirement now.

Snapshots of testing result:

Best Regards,

Jack Chen

[BBIUser]

Thanks for the explaination @v-shex-msft Jack!

I wanted to make sure if my requirement is currently possible to achieve in Power BI or not and yes, I have implemented the solution as in 1st, 2nd and 3rd screenshot but in different pages.