topic Re: Custom Table or Matrix in Custom Visuals Development Discussion

Custom Table or Matrix

Anonymous — Wed, 27 Oct 2021 15:04:50 GMT

Hello my friends.

I'm in need of help imagining how to create a table or matrix like this in power bi. I have a fact table with the year last, current year values, and the dimensions tables with the families. The values produced and Billed are columns with values. Is it possible to produce a table or matrix that looks like this? Since the second column year last (2020) would have the ability to filter previous years and in the Line U$ the capcity of putting total and average between parentheses.

If it's not possible, I'll try to find other method. I appreciate your time and thank you.

Re: Custom Table or Matrix

lbendlin — Sun, 31 Oct 2021 22:15:34 GMT

Shouldn't row 13 say "Total Produced"?

Re: Custom Table or Matrix

Anonymous — Mon, 01 Nov 2021 13:12:34 GMT

True, I typed wrong

Re: Custom Table or Matrix

lbendlin — Mon, 01 Nov 2021 14:01:24 GMT

It is possible to achieve this with a custom matrix design but be prepared for a lot of work

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591

Re: Custom Table or Matrix

Anonymous — Mon, 01 Nov 2021 14:50:54 GMT

I figured i'd have a job, thanks for giving me a direction.