Matrix into P&L Statement

[Hijau]

Hi community,

Currently trying to turn a matrix into a P&L statement. Have been lurking here for a while so I've seen a lot of recommended video's and posts but I'm still struggling with the fact that there are cells showing blanks. I would like for the matrix to only show the values.

Any help would be greatly appreciated!

Thanks in advance.

Cheers, 

Dexter

[v-jiascu-msft]

Hi Dexter,

I have to consult the idea P&L. What's relationship between Matrix and P&L?

Just see from your image, you put the wrong hierarchies in the Row of the Matrix. The parent level has itself as the child level. What's your data structure? What's the expected result? Can you share a dummy sample?

Best Regards,

Dale

[Hijau · Accepted solution]

Hi Dale,

Thanks for your reply. 

I figured it out: 

 Now I'm trying to subtract the total of 'Uitgaven' from the total of 'Omzet'! 

Cheers,

Dexter

[Anonymous]

Hi @Hijau,

I am a beginner making P&L statement in PBI.

Please can you share your PBIX file with me , if you don't mind?

Thanks,

spanda

[anilkumarch]

Un select " Show Items with no data" for respective row dimension

[Hijau]

Hi community,

Currently I'm trying to turn the matrix visualization into a P&L statement. I've seen a lot of recommended video's and posts so I'm progressing. Although now I'm struggling with the fact that my matrix is showing rows that don't have values and also don't have to be shown. Can't figure out how to insert an image so here's the link of Dropbox: https://www.dropbox.com/s/9e8yuhtnm1epecj/Matrix.PNG?dl=0.

Any help would be greatly appreciated!

Thanks in advance. 

Cheers,

Dexter