Hello experts ,
I have a data model just like the shown below:
As you can see, I have a relationship between the column "Area" and almost all the tables that I have in my model.
The "Area" filter is the first one on my dashboard.
On the other hand, I had to create a data bridge and a master calendar for table 1, because I have two date columns that I needed to visualize in one chart. For that relationship, I have a canonical date from which I filter the information by date groups: "All to 30 days in the future" and "All to 60 days in the future." This is the second filter.
My issue is that when I filter by date, some of the "areas" don't have information for that date in Table 1, and because of that, all the tables remove that "area," even though those tables are not related to that filter because they don't have any date on them.
Do you know how I can ignore the "date" filter for all the other tables?
Thank you,
Regards
Accepted Solutions
