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.
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.
Thank you so much!