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 and PowerBi uses the quarter to allow a drill-down to the quarter.
The problem occurs because I want to add a LastYear(Same Period) field to dispaly ONLY on the Quarterly period which is when I drill down. In other words, when someone clicks the Year and drills down to the Quarters, that is when they would see the Q1, Q2, Q3, Q4 with 2 values for each.
Is something like this possible?
George Eivaz
1 Reply
Try 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>)
