How to change the 'x-axis query item' dynamically.

[arroju_venkat]

Hi,

Could you please explain me how to change the 'X-axis query item' dynamically in bar chart by creating a prompt.

Thanks,
Venkat.A.H

[Suraj]

just replace the x-axis query item by a case stament:
case
when prompt = 1 then [product line]
when prompt = 2 then [product type]
else [year]
end