0.05% is too less not sure how many records. but it seems there are bunch of field values not same across both the tables. unless you have matching or associated values your chart wont display anything.
I'm not saying the chart or expression or data is wrong but I think as per your subset ratio the dim to fact association is weak and not have enough amount of matching record.
The key field - the field that connects your two tables - the dimension table and the fact table, will only match rows between the tables if the values match. So check why the values in the dimension don't match the values in the fact table. The fact table should have 100% subset ratio on the key field that goes to the dimension table.
Is it a date or timestamp in either of the source database columns? Maybe you need to do a Floor() to get the exact granularity of a full day...