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

KaySunset — Fri, 15 Sep 2023 13:03:02 GMT

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

topic PBI Matrix with certain rows in different layout (result lines) in Custom Visuals Development Discussion

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