Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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
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.
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |