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

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.

Reply
KaySunset
Helper I
Helper I

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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