Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
KaySunset
Helper II
Helper II

PBI Matrix with certain rows in different layout (result lines)

Hi everyone,

 

I have a report with a large data table that uses a Zebra BI table for visualization (> 32 Mio rows). While I'm a big fan of those, the dataload just seems too much - the visual is soooo slow, as soon as I switch it to a matrix, it performs quite well.

Therefore I'd like to rebuild the table depicted below with a matrix visual (well aware that some nice features of Zebra BI will be missing). It doesn't have to look exactly alike, but I need to have an optic distinguishment of attributes "03_GrossProfit", "06_Cont_BeforeMarketing", "09_Cont_AfterMarketing" and "11_Contribution". As for now you can see that it is in bold font and has lines separating the above. 

Is there any way to achieve one or the other with some magic in a PBI matrix? I have built a sample file that represents the way the data is stored (much less data, of course). There's also a matrix visual that depicts that data almost as I need it 😉 

 

Hope there's a way!

 

BR,

Kathrin

KaySunset_1-1694782582542.png

 

 

0 REPLIES 0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors