Hi All,
I have a column chart with 2 dimensions plotted - YEAR and PRICE BRACKET and measure is a % calculation , I also have a prompt on the report page to select the Price bracket.
I want to conditionally hide/display the price bracket on the column chart based on prompt selection.
I cannot use this as a filter as it impacts the percentage calculation which is a measure used on the graph.
Attached the report layout for reference.
Please suggest.