Forum Discussion
Multiple Relationship for slicer calender
I have two bar charts that show forecast and revenue by year for different business unit.
There is a relationship between revenue table and forecast table that allows the business units to be filtered. However, I need to add another slicer that filters the charts by years as well. Since there can only be one active relationship between the tables, how can I add a slicer that filters both the revenue and forecast table by year?
5 Replies
PadycosmosSolution Sage
You can add an inactive relationship. It appears as a dotted line instead of a solid line for an active relationship. An inactive relationship becomes active when invoked.
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.
- Padycosmos
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.