I need to create a bar chart with multiple measures. Each measure calculates the cost in a specific year, and is displayed in different specific color when the specific year is selected. So if the user selected 2023-2024 then 2 bars will be displayed.
With a bar chart I can set a condition for each measure, but I cannot set a specific color. I can use a color scheme but the color does not remain constant and depends on the user's selection.
As an alternative I can use a combo chart, I can define a specific color but I can't set a condition.
