SSRS Style Matrix Groupings in PowerBI

Question

Hello,&nbsp;My company is evaluating PowerBI as a possible replacement for SSRS.&nbsp; However I'm beginning to see that PowerBI seems to be designed for higher level dashboards, and may not be as sophisticated as SSRS for building complex reports.&nbsp; Specifically I'm looking to replicate the matrix grouping functionality in SSRS which would allow me to place a chart (or really anything I wanted) into a grouped cell, and have that item repeat for each group.&nbsp;This wouldn't require any hard-coding of groups.&nbsp; I just needed to select a field on which to group.&nbsp;As an example, grouping on country,&nbsp;Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales Breakdown----------------------------------------------Canada|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pie Chart Here for Canada&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |----------------------------------------------Mexico|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pie Chart Here for Mexico&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |----------------------------------------------USA&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pie Chart Here for USA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;Unless I'm missing something, the PowerBI matrix only seems to support simple text data.&nbsp; Any ideas on how I could achieve what I'm looking for here?&nbsp;Thanks,Dan

v-danhe-msft · Accepted Answer

Hi&nbsp;dmoor349&nbsp;,
Based on my research, I am afraid you could not achieve this feature, but you may refer to below link that could design your reports with&nbsp;Report Builder and published in Power BI Service:
https://docs.microsoft.com/en-us/power-bi/paginated-reports-report-builder-power-bi
&nbsp;
Reagrds,
Daniel He
&nbsp;

Forum Discussion

SSRS Style Matrix Groupings in PowerBI

2 Replies

Related content

Matrix column not grouped

PowerBI - Matrix table, hide values used only for a visual calculation

Matrix Adding total from previous Group

Fabric & Azure Data User Group Program Requirements & Benefits

Community User Group Experience