Forum Discussion
Cross-filtering not showing all data
Super UserHi, Ismar
you can have Data Table that has columns that either have Month as Text or Month as Number.
You then map the tables accordingly, make sure you map Date Table with Your Excel table and SQL table, don't map SQL and Excel together.
Could you share please how your schema looks like, please?
The thing is, I already have excel and SQL directly connected through some other field (category) as a many-to-many relationship. That might be the problem. When I try to make both active through date table, I get warned about ambiguity.
- vojtechsima
Can you share your model, please?
- vojtechsima
Do you have to create connection between those two when you will create a mutual connection to Date Table?
Also many to many relationship is never the best option or Both cross filters.
Try to recreate your model and add more dimensional tables, so you have ideally one to many relationship.