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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.