'Grouping multiple columns in Paginated Report

I have a Power BI dataset as a data source to a paginated report builder. This dataset when display on a table, it looks like below enter image description here

This is a column picker report, for example, when I pick all columns from the parameter, it should return above screenshot. If I pick 3 columns, it will return enter image description here

Note - the figures are repeating.

WeekYear, AveragePrice, Sales and NetProft are not part of columns passed as parameter.

What I want to achieve for my table visual to aggregate whatever columns selected based on WeekYear, AveragePrice, Sales and NetProft. As shown below: enter image description here

How can I achieve this SSRS Table or paginated report?

reporting-servicesssrs-2012ssrs-tablixpowerbi-paginated-reports


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Report wont run when using OLE DB connection

ORA 01797- operator must be followed by any or all

SSRS fixed position of tablix in body of the document. Visual Studio

A timeout (30000 milliseconds) was reached while waiting for a transaction response from the ReportServer service

SSRS - Disabling export options (eg. PDF) for individual reports

Tabbed Reports in SSRS

SQL server report error - "rsInternalError"

Strange issue in SSRS 2016. I am unable to select parameters or run the report intermittently, it works fine most of the time

SSRS Reporting in Blazor

Setting a list of several values to one SSRS parameter in "Available values"

SSRS Tablix border size inconsistent

The version of the report server database is either in a format that is not valid, or it cannot be read

Reporting Services - show multiple values for a column horizontally rather than vertically

SSRS Data Driven File share account - impersonation error

SSRS avoid WHERE clause if select all is selected