I have a bar chart which has Funds broken down into Category A and B.
I need to hide and show based on certain conditions.
1. If no selections are made on 'Category', then the bars should show sum of all the Funds.
Refer to my Result table. It shows all the funds in one bar broken down into Quarters, but the years are hidden for some reason. No idea why.
2. If I select 'A', only bar for 'A' should show up and if I select 'B', only bar for B should show up. If I select both A and B, then two bars for each category has to be shown instead of one combined bar.
Right now, it is done but I have the same issue. Years is being hidden. I want to break down the Funds into Quarters and Years.
I have another chart with YTD values and ValueList is being used. I am not sure how to implement the same logic on this chart. I have attached the QVW with the YTD chart added. Any help with this is really appreciated 🙂