Forum Discussion

crkf20's avatar
crkf20
New Member
2 years ago

Matrix Visualization help

Im building an income statement as a matrix in Power Bi, I have my revenue items coming from a table that strictly has revenue by each product. I have my expense data coming from the GL that shows ex...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, crkf20 

Can you provide some sample data that doesn't include privacy and the output you expect?

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

crkf20's avatar
crkf20
New Member
2 years ago

I cant provide sample data, but what this is what i can provide: 

I have 3 levels here, notice how for the 2 I have broken out, (Total Revenue) and (G&A) they look correct. Issues occur when i pull in level 3:

Level 3 has data in it for Non-recurring revenue, but Administration just has administration in it. I dont want level 3 applied to Administration under G&A I only want it applied to specific areas.

 

Furthermore the numbers that are populating to the right need to be based off of grouping from my GL. I only need these to be in certain fields. they should not be applied to revenue items. This view is correct for Finance: 

This view is not correct for Hardware Revenue: 

THere should be nothing showing up under hardware.

 

I need to figure out a way around this