Forum Discussion
Interactive sorting for adjacent groups in Power BI Report Builder
Hello
I have a question regarding paginated reports creation in Power BI Report Builder.
Is it possible to setup interactive sorting for two adjacent groups?
As an example:
I have two row groups: subtotals for sources (SourceSubTotal) and the group for customers (Customer).
One of the table columns displays total number of orders summed for each source or customer. I'd like to use this column for interactive sorting, so both sources and customers will be sorted the same way. But sorting menu allows me to select only one group.
I tried to use different options of "Apply this soting to all groups and data regions in", but seems like it doesn't affect anything.
5 Replies
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:
SpoilerCustomer 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
