Hey Guys,
In the attached dashboard I have three sheet,
i) Sales by Category
ii)Detail Data
iii)"Click to View Detail Data Sheet" Text.
My requirement is when first time user open the dashboard, he should be able to view only Sales by Category view and "Click to View Detail Data Sheet" Text.
Detail Tab should be hidden. When user clicks on any bar(Example: Furniture) in the Sales by Category Graph then action should pass and show detail Tab with Furniture details only.
Again when clear the selection in bar graph then Detail Tab should be hidden.
If user clicks on "Click to View Detail Data Sheet" Text. then detail Tab should display with all the data like as it is without any filter. Again if he escapes the action then detail tab should be hidden. I have created two action for the same but it is not working as expected. It would be great if anyone can provide solution on this.
Hi Roisha,
The reason your actions aren't working is because they're both trying to exclude all values when not selected. So when you click on show all data, nothing shows as your bar chart action is saying 'exclude all data'. The same applies the other way round. They are basically counteracting each other. Do you need to be hiding all the data? Why not just show all the data from the start and have the user filter by category using the bars?Thanks,
Jack
