1 of 1 people found this helpful
The filter is going to effect everything in the view. However, if you want to only show one value at a time on one axis and all on another axis, then a parameter and calculation could be used. I have attached a sample workbook showing this (I set the null values to be white in the color legend). Hope this helps!
Thanks, Tracy. Ths is helpful, but I still cannot get them on the same graph using mixed types (e.g., a line and an area type) because the data is still there in both cases.
Appreciate the help.