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.
Thank you very much, everyone, for their support and work, and thank you for your solution. That works perfectly. Unfortunately, I have added the 1 value in one more brackets, which did not work for me.