I’m trying to implement a bar graph between two of the same KPI’s but with different filters on them. I’ve created the bar chart with both KPI’s displaying by month, and then I added two dropdown buttons that select the plant/warehouse of interest. Both of these dropdown buttons’ values are then set to text variables I created.
I want to now filter each KPI bar segment based on the button values. So the end result would be two bars for each month, with one bar being filtered on the first button’s value and the second bar being filtered on the second button’s value.
Below is what I have now, just without the functionality of the filters to distinguish each bar.
Any help is greatly appreciated. Thanks.