Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
danielpaduck
Helper III
Helper III

Matrix Report That Acts Like A SSRS / Excel Report

‎12-05-2023 05:45 AM

Hi,

 

Does anyone know what the best way to try to reproduce an Excel type report to Power BI?   The following is what the Excel looks like:

danielpaduck_0-1701783794917.png

 

I have been able to do this with a Matrix but essentially I am unioning all the detail with a different record type and sub record type as an identifier.  However, the data set is large because it is essentially Income Statement data that is being pulled 8 or more times for each record type.   Thus, can you do this without so many union queries? 

 

Thanks! 

 

Thus, 

Labels:
Message 1 of 3
322 Views
0
1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

‎12-05-2023 05:57 AM

HEllo @danielpaduck ,

 

check these https://youtu.be/J4317R5BvsA?si=jZ9FwogSSv2QSQRj

https://youtu.be/PI52ckgezzA?si=sl8k1g2n0RYn35vZ

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!


View solution in original post

Message 2 of 3
306 Views
0
2 REPLIES 2
danielpaduck
Helper III
Helper III

‎12-05-2023 07:45 PM

Cool! I will check that out! Thanks! 

 

Message 3 of 3
283 Views
0
Idrissshatila
Super User
Super User

‎12-05-2023 05:57 AM

HEllo @danielpaduck ,

 

check these https://youtu.be/J4317R5BvsA?si=jZ9FwogSSv2QSQRj

https://youtu.be/PI52ckgezzA?si=sl8k1g2n0RYn35vZ

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!


Message 2 of 3
307 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All