Forum Discussion
Multiple Relationship for slicer calender
I need the relationship to be active.
Like when I select different business unit, both the values on forecast and revenue chart change becase there is already an active relationship between these two column. That is not the case with the year colum, only only chart changes depending which tables value I have it selected for the slicer. I basicaly need two active relation ship from two different tables. One for the business unit and the other for the forecast.
Could you provide sample data to understand the context?
Something Like this.
Basically, I need a slicer visual that has the filter option for business unit and year. Because there is a active relationship betweent the business units columns in the 2 tables, when I a select one business unit, both the charts display the accurate values. But since I cannot create another relationship between the years column, when I select a particulr year from the slicer drop down, it only shows accurate value for one of the charts. Like how would I create second active relationiopship in two different columns from different table that does not have one to one relationship.
Could you provide sample data in the year column of both the tables?