Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I met with such an unusual problem: In the table there is a list of dates for the current month, in the filter there is a list of companies.
When I select any company in the filter, I get a list of January dates, but when I select one company (Volkswagen) in the filter, an empty list of dates appears.
The option show items without data is enabled. There are no other applied filters, including in the filter panel.
If the behavior was the same for all companies in the filter it would be clearer, otherwise it’s not clear at all where to look for the reason. Any ideas? Thank you in advance for your reply.
Solved! Go to Solution.
Found the reason. The point is in the chain of active links and the fact that one of the tables has "many-to-many" relationship with the calendar and double filtering in both directions, while in the other tables "one-t-many", I changed link filter type to "one" (the calendar filters the linked table) in the problematic relationship and everything worked.
Found the reason. The point is in the chain of active links and the fact that one of the tables has "many-to-many" relationship with the calendar and double filtering in both directions, while in the other tables "one-t-many", I changed link filter type to "one" (the calendar filters the linked table) in the problematic relationship and everything worked.
@roman_gorbunov , the date is coming from another dimension? means not from fact and company table
Yes , it comes from another table (Calendar table)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |