reporting-servicesdaxssrs-tablixpowerbi-paginated-reports

How to remove the auto generated total column from paginated reports in power bi report builder


I am trying to develop a matrix chart in Power BI report builder (paginated report). When I drop the data field, it auto-generates the total column like this which are highlighted yellow

enter image description here

The property of the paginated reports are like this

enter image description here

Can someone please tell me how to remove the yellow highlighted auto-generated column from he report?


Solution

  • I don't think that is a total column, otherwise it would show in the report design.

    It looks like your data may contain rows with blank years/months and/or blank portfolio/account names so the matrix is simply aggregating those as it would with any other data.

    I suggest you look at the output of your dataset query and filter the data out there or if that is not possible for whatever reason. Filter the data out in the dataset filter properties.