SSRS Interactive Sorting on the Column grouping

Navinkumar Kanagaraj 86

I have a tablix and I have a row group and a column group on top of it.

I want to apply interactive sorting on top of the Column grouping.
That it should work like, the Rows groups/ rows in the tablix should be sorted based on the attribute values.

What I want is :

When I click sort button near to caps, the value "AWC Logo cap" should go the top and the Row related to it also should to the top. (the Row I want in the top is highlighted in red.)

is there any possibility. Because i have tried interactive sorting with applying Choose what to start as "Category", in the interactive sorting option and sort by as "Product Name", and apply it to the Category data group.

but it throwed an error that scope can't be in different axis.

Please provide me some Clarity!

Navinkumar Kanagaraj 86 Reputation points

2022-05-11T14:08:43.493+00:00

Please suggest the process that can also work on Power BI Report Builder.
Joyzhao-MSFT 15,601 Reputation points

2022-06-06T02:03:40.7+00:00

Hi @Navinkumar Kanagaraj ,
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy

1 answer

Joyzhao-MSFT 15,601 Reputation points

2022-05-12T02:18:40.017+00:00

Hi @Navinkumar Kanagaraj ，
Follow these steps to set it up:

1. Set up interactive sorting, when clicking the sorting icon, the product names will be sorted according to the first letter.

2. Set the expression of [Product_Name] font as follows: =IIF(RowNumber("Subcategory") = 1, "Red", "Black")

3. Preview

Best Regards,
Joy

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Joyzhao-MSFT 15,601 Reputation points

2022-05-12T02:49:03.567+00:00

SSRS report developers face a common problem with interactive sorting of column groups in a Matrix, whenever we add an interactive sort on a column group, the sorting symbol appears but when we click on it it doesn't affect . This is one of the limitations of SSRS. So if you use the method of adding sorting to the column group, it will be a lot more complicated than the above method.

If you want to set up interactive sorting of column groups, please refer to the following links:
SSRS – Interactive Sorting on Matrix column group

Navinkumar Kanagaraj 86 Reputation points

2022-05-12T04:54:20.423+00:00

Thank you @Joyzhao-MSFT .

the Link what you provided is helpful but I need the same in Power Bi report Builder, where we don't have the option "Go to report", In the Action tab. If you have any please help out. And thanks for the answer provided.

Joyzhao-MSFT 15,601 Reputation points

2022-05-12T06:52:58.463+00:00

Hi @Navinkumar Kanagaraj ，
I checked the PBI Report Builder and there is indeed no "Go to Report" option, even though I see a lot of similar questions on the PBI forums.

(PBI) Report Builder is usually used for relatively simple reports. If you are committed to dealing with relatively complex PBI reports, one way is to use Desktop to design reports, and Desktop is also free to use.

Also, if you are used to using PBI Report Builder, due to the similarity between PBI Report Builder and Report Builder, you can download Report Builder to design PBI reports. Report Builder supports "Go to Report" Drillthrough Action, but you need to manually deploy the report to PBI Server.

If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSRS Interactive Sorting on the Column grouping

1 answer

Your answer