Forum Discussion

JoseD's avatar
JoseD
Frequent Visitor
4 years ago

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

  • 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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity 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's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity 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