Forum Discussion
City filter options disappear when I select In a date filter any 2020 date
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!
3 Replies
- NickolajJessen
Solution Sage
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 - Greg_Deckler
Community Champion
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.
- v-henryk-mstf
Community Support
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