Interactive sorting for adjacent groups in Power BI Report Builder

[Frostwind]

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.

[Anonymous]

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

[Frostwind]

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:

Spoiler

Report test data:

Spoiler

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

[Anonymous · Accepted solution]

Hi @Frostwind ,

I updated your sample rdl file, please check if that is what you want.

Best Regards

[Anonymous]

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

[Frostwind]

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.