Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JoseD
Frequent Visitor

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 3
v-henryk-mstf
Community Support
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.

vhenrykmstf_0-1655188538585.png


Best Regards,
Henry

 

Greg_Deckler
Super User
Super User

@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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
NickolajJessen
Solution Sage
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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.