Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a stacked pie chart which displays states of orders per year. My dimension is
=YEAR([Data.OrderDate])
and my measures are
=Count({<[Data.State] = {'Open'}>} DISTINCT [Data.OrderNo]&'|'&[Data.State])
=Count({<[Data.State] = {'Closed'}>} DISTINCT [Data.OrderNo]&'|'&[Data.State])
=Count({<[Data.State] = {'Cancel'}>} DISTINCT [Data.OrderNo]&'|'&[Data.State])
My stacked vbar chart is one of many charts in the page. And I also have a filter pane which includes Order date as:
=YEAR([Data.OrderDate])
When I choose a specific year I want my stacked bar chart display all years regardless of Order date chosen, as it has never been filtered. How can I accomplish this?
Regards.
If I would have been using an aggregate function such as SUM, COUNT or AVG I would have been placing {1} inside the function, but where should I place the {1} in this expression?
=YEAR([Data.OrderDate])
That is the problem. I need year filter for other charts and tables in the report but not this one. I am using year to create x-axis values in my chart.
My stacked-bar chart already displays Order for all available years and I do not want it to get filtered by year when I filter other charts and tables on the same page. I want to stay still whatever the year filter is set to.
Thank you very much for your help. But my page still filters when I select a year from the filter pane.