Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |