1 of 1 people found this helpful
Create two worksheets, one with multiple bars, one with single bar. Then use a filter/parameter to drive which one is visible using these techniques:
Thank you for the link to the video. This will be a useful method on future dashboards.
I tried the following before the viewing the video and it appears to be working.
Created a parameter: "Summary" with yes no options.
Replaced the Category pill on the row shelf with a calculated field
IF [Summary] = TRUE THEN 'ALL' ELSE [Category] END