Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |