Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a COVID cases fact table, a date dimension table and a cities dimension table. I have filters to click and select the city and the date, when I select 2020 in the date the city filter options disappear, if I do it with 2021 or 2022 it works fine and does not disappear. In the fact table there is data in 2020 for any city.
Here's a short video of what is happening: https://gyazo.com/f9ebe87926f1039fb5e3a30e4d1ec5c1
I have also put the tables in order to make it more clear, (sorry the names are in spanish), I don't understand why could be this happening, when I filter the date, those cities ID are appearing in the fact table and should linked to the cities table, works fine with 2021 and 2022 dates but not for 2020.
I have the city and date table related to cases fact table with one to many relationship: https://gyazo.com/8260dceb8015c79afad4c3fda4322589
I post also the full model just in case is usefull: https://gyazo.com/ca44e0bfcd58a827f6ebdd404ca34457
Any help is appreciated, thanks!
Hi @JoseD ,
Can you point out the specific tables from which the table visual fields are used in the screenshot below? Looking forward to your reply.
Best Regards,
Henry
@JoseD Couple things that I see. First, looks like a many-to-many relationship between your fact table and cities. Plus, looks like a weak relationship so seems like you are using a composite model. Generally when you are doing that you want to ensure that your storage mode is set to Both for your dimension tables.
One thing you could start with is making you you don't have any many to many and bi-directional filters.
Try creating aa visual with ID_Fetcha from the COSAS and CALENDARIO and see if there are any inconsistencies becomming apparant
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |