Forum Discussion
Interactive sorting for adjacent groups in Power BI Report Builder
Hi Frostwind ,
You can refer the following official documentation to get it:
Add interactive sort to a table or matrix in paginated reports
If the above one can't help you get the expected result, could you please provide the following info for the further troubleshooting?
- Provide some sample data for these two groups
- Row Groups settings
- Visual settings(Table, Matrix or other?)
- The expected result base on the previous sample data
Best Regards
Hello Anonymous
Thank you for the reply. I read the documentation, but was not able to find a solution there.
You can check the minified report example here: download PBI Report file
The desired result is to apply interactive sort to both Customer and SourceSubtotal groups.
Report structure:
Report test data:
| Customer | Source | Orders |
| Mike | Amazon | 15 |
| Mike | Ebay | 17 |
| Mike | Etsy | 5 |
| David | Ebay | 20 |
| David | Etsy | 10 |
| Angela | Amazon | 18 |
| Helen | Amazon | 13 |
| Helen | Etsy | 10 |
| James | Ebay | 11 |
| James | Amazon | 5 |
Hi Frostwind ,
What's your expected result base on the sample data? The below screenshot is what you want or not? Do you want to sort the sum of order base on both Custom and Source?
Best Regards
Hi Anonymous
I'm sorry for the long delayed response.
Yes. My goal is to sort both sources (in SourceSubTotal group) and customers (in Customer group) by their total sums or orders.