Relation

[Anonymous]

Hi all,

I created a key by year/month under shop budget table and shop account ledger table seperetly. The date in Shop budget table is every day, the date in Ledger table is not every day.  The two table are linked by this key as 1 to many, budget table filters ledger table as following ,

I draged the key from Budget table is as following, there are 12 rows related to 12 months.

The issue is , once I drag the key from Ledger table, in January, there is no data in Ledger table, and the January is gone. I assume, the row of January in Ledger is supposed to be blank, but why it is gone????

Thank you in advance!

[vicky_ · Accepted solution]

You are correct - it is blank because there is no data. If you want to see the January results, you will need to right-click on the field in the and select "Show Items with No Data". See this link for more details: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data