My problem is that, when I use quick filter any sheets is disappeared on the dashboard,because they contain default value
.How can I show it, e.g if the sheet is not contain data(age) between 19-25 year, show 0 value???
You can do this using a parameter as opposed to a quick filter. Create the parameter and write a calculation that is similar to the following:
if [Parameter]=[Age] then [Age] else 0 end
Hope this helps!
Retrieving data ...