SSRS Style Matrix Groupings in PowerBI

[dmoor349]

Hello,

My company is evaluating PowerBI as a possible replacement for SSRS.  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.  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.

This wouldn't require any hard-coding of groups.  I just needed to select a field on which to group.

As an example, grouping on country,

Country             Sales Breakdown
----------------------------------------------
Canada|
            |
            |       Pie Chart Here for Canada
            |
            |
            |
----------------------------------------------
Mexico|
            |
            |       Pie Chart Here for Mexico
            |
            |
            |
----------------------------------------------
USA     |
            |
            |       Pie Chart Here for USA
            |
            |
            |

Unless I'm missing something, the PowerBI matrix only seems to support simple text data.  Any ideas on how I could achieve what I'm looking for here?

Thanks,

Dan

[v-danhe-msft · Accepted solution]

Hi @dmoor349 ,

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 Report Builder and published in Power BI Service:

https://docs.microsoft.com/en-us/power-bi/paginated-reports-report-builder-power-bi

Reagrds,

Daniel He

[dmoor349]

Thanks for the reply Daniel.  That's what I was afraid of.

Looks like we'll have to keep SSRS in the picture for now.

Dan