Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
a-5
Contributor III
Contributor III

Hide/show bar in bar chart based on filter value

Hi, 

In my sheet, the user can choose whether to see the actual result against FY target only or both YTD & FY targets. 

How can I create a condition in my bar chart that:

- If the user has selected "FY" in filter, only FY target bar is shown in the bar chart 

- If the user has selected "YTD" in filter, both FY & target bars are shown in the chart?

Bar representing the actual result is also already included in the same chart.

 

Thanks!

Labels (2)
1 Reply
a-5
Contributor III
Contributor III
Author

Anyone able to help with this one? I'd also want to hide the measure names from legend that are not shown.. 

 

Thanks!