Last Modified Date: 19 Oct 2019
ResolutionUse either of the following options:
- Enable the "All" selection on the filter's Customize menu
- Create or use an existing dimensional hierarchy, and change the filters to use "All Values in Hierarchy" instead of "Only Relevant Values"
Cause"Only Relevant Values" does not change the current selection in a filter, only what selections are available. Removing the "All" option when using multiple "Only Relevant Values" filters can result in a situation where there are no valid values in the data. If Filter A's selection becomes invalid when Filter B is updated, Filter C showing "Only Relevant Values" will become blank.
Additional InformationSee the attached example workbook for a demonstration of this issue and its solution.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials