Forum Discussion
Conditional Visibility on Drill Down Chart
Good Afternoon, I Have a Clustered Column chart with work awesome. It allows users to see our sales by Year. It also allows users to drill down to quarters because the Axis Field is a date field a...
Nhallquist
Helper V
Helper VTry Creating these 2 measures using the DAX formulas below. you may need to tweak them to accomodate a year selection, but they should work.
Last Year: PREVIOUSYEAR(<dates>[,<year_end_date>])
YTD: TotalYTD(<expression>,<dates>,<filter>)