Forum Discussion
Solved
Line and Clustered Column Chart Help - Negative 100%
Hey I've got a Line and Clustered Column Chart that is showing valuable information, but it is also showing things that a irrelevant. The green line is telling me the Year over Year percentage ch...
Hi gussie ,
Based on my test, you could use below measure for Line value:
Measure = IF(ABS([YoY Percent Change])<>1,[YoY Percent Change],BLANK())Or add <>BLANK() && <>0 in your YOY change measure like this:
YoY Percent Change 2 = VAR _LastYear =CALCULATE( SUM('Table'[Values]), FILTER('Table',[Date].[Year]=2020)) VAR _ThisYear =CALCULATE( SUM('Table'[Values]), FILTER('Table',[Date].[Year]=2021)) RETURN IF(_LastYear<>BLANK() && _LastYear<>0 && _ThisYear<>BLANK()&& _ThisYear<>0 , DIVIDE(_LastYear, _ThisYear,0)-1 ,BLANK())Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try create Visual Level Filter for YoY Percent Change...
Thanks Farhan,
I've tried the following ...
is_before_today = IF(dim_date[actual_date] <= TODAY(), True, False)as a fitler on the visual but this does nothing...