Yes, you can assign the dropdown selection to a variable and use that variable in case when clause in the column chart.

Thank you for your answer. And how can I integrate the statement CASE WHEN "drop down is empty" THEN...

is there a syntax for it or do I miss something here?

Best regards

case when <%variable> is null then ... end

Unfortunately this doesnt work. An error occurs when no value is selected in the dropdown menu. The error disappears after I select a value.

Sorry, please ignore earlier reply.

Below method will work, but it will apply the filter to the entire analysis and not to a specific component.

1. Limit the number of in column chart to 5 and add sorting appropriately
2. Dimension should be the vendor column
3. You have to add dropdown (under selection components) component (NOT button dropdown under design components) and dropdown items should be the vendor column