Forum Discussion
Data modelling
Hi i have two separate spreadsheets that I've loaded into power bi. Some of the columns have the same info ie month, department and product code. The other columns contain a value for a financial...
Hi Analyst26,
It looks like the issue is due to a relationship problem in the data model. Although you’ve connected the two spreadsheets by Product Code, fields like Month and Department used in the matrix may not be properly related across both tables. Because of this, Power BI is unable to filter both datasets correctly, resulting in 0s for one of them.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu