Forum Discussion
rajendraongole1
Super User
Super UserHow to Hide Last 4 Quarters data in X axis Dynamically
Hi I have an X axis with continous quarterly data from 2017 till data. i want to hide last 4 quarters and show upto 2018-Q4. if next april comes i.e 2020 -Q1 , i have to get 2019-Q1 automaticall...
HI rajendraongole1 ,
You can try to use the following measure to check current category and return tag, then you can use it on the line chart visual level filter to only display 'Y' tag records:
Measure = VAR _last = MAXX ( ALLSELECTED ( Test[YearQuarter] ), [YearQuarter] ) VAR _curr = LEFT ( MAX ( Test[YearQuarter] ), 4 ) & RIGHT ( MAX ( Test[YearQuarter] ), 1 ) VAR prev = LEFT ( _last, 4 ) - 1 & RIGHT ( _last, 1 ) RETURN IF ( _curr < prev, "Y", "N" )Regards,
Xiaoxin Sheng
HI rajendraongole1 ,
You can try to use the following measure to check current category and return tag, then you can use it on the line chart visual level filter to only display 'Y' tag records:
Measure =
VAR _last =
MAXX ( ALLSELECTED ( Test[YearQuarter] ), [YearQuarter] )
VAR _curr =
LEFT ( MAX ( Test[YearQuarter] ), 4 ) & RIGHT ( MAX ( Test[YearQuarter] ), 1 )
VAR prev =
LEFT ( _last, 4 ) - 1
& RIGHT ( _last, 1 )
RETURN
IF ( _curr < prev, "Y", "N" )
Regards,
Xiaoxin Sheng
rajendraongole1Super User
Super User@ Team- Thank you for time and support