Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you check to see if attached is what you are looking to do?
Check now
Can you check to see if attached is what you are looking to do?
@sunny_talwar Hi Sunny, when nothing is selected in category, I need to show just two bars per quarter but no stacking( Should be of same color and total value).
I think I got it. I enabled my third expression and added similar conditions to hide and show. The answer to my problem was a dummy third dimension which is '=1' you used 🙂
Thank you so much.
Super, I am happy you were able to figure it out 🙂
🙂
@sunny_talwar Small help.
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 🙂
Attached where? a new thread?
Here it is
Is this the chart?
What is wrong?