Forum Discussion
thetenz
3 years agoFrequent Visitor
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 f...
Padycosmos
Solution Sage
3 years agoCould you provide sample data to understand the context?
thetenz
3 years agoFrequent Visitor
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.
- Padycosmos3 years ago
Solution Sage
Could you provide sample data in the year column of both the tables?