Filter bar chart depending on field parameters and hide bars when there are no comparison values

Hello,

I have the following problem:

I have created index values based on the Value column. Blue is assigned an index of 100 for each product. The other colors (red, green, and yellow) are then indexed based on their values.

This works without any problems.

Now I want to display the whole thing in a diagram. To do this, I have inserted the measures for index calculation in field parameters.

This allows me to filter which of the three colors (red, green, and yellow) is compared with blue.

Now I don't want to display the products that have no comparison value for blue. This varies depending on which color was selected in the filter.

The problem is that I cannot set all index calculations filters for the three colors (red, green, and yellow) to is not 0 (or is not blank) because it works like an AND condition, i.e., nothing is displayed anymore.

So what I need is a measure that, depending on the color selection in the filter, hides the products that currently have no comparison index.

Measures:

Blue as index for comparison = DIVIDE (Table1[Blue filtered for Comparison],Table1[Blue filtered for Comparison],0)*100

Blue filtered for Comparison = CALCULATE(AVERAGE(Table1[Value]),
Table1[Color] = "blue")

The following code I used for all three comparison colors (green, red and yellow) and changed just the color name. Here is the code for green:

Green as index for comparison = DIVIDE (Table1[Green filtered for Comparison],Table1[Blue filtered for Comparison],0)*100

Green filtered for Comparison = CALCULATE(AVERAGE(Table1[Value]),
Table1[Color] = "green")

Field Parameters:

Parameter = {
    ("Green as index for comparison", NAMEOF('Table1'[Green as index for comparison]), 0),
    ("Red as index for comparison", NAMEOF('Table1'[Red as index for comparison]), 1),
    ("Yellow as index for comparison", NAMEOF('Table1'[Yellow as index for comparison]), 2)
}

Data: