Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Anyone able to help with this one? I'd also want to hide the measure names from legend that are not shown..
Thanks!