%yoy sales is not showing properly

[Shineccx007]

Hello,

I have switch the below matrix chart to line and bar graph.

For the data under this customer, some month didn't have the sales amount, and the measure looks so wired. Any solution to fix the Yoy%?

Thanks!

[rajendraongole1 · Accepted solution]

Hi @Shineccx007 - Can you try below measure for %yoy Sales 

%YoY Sales =
VAR CurrentYearSales = SUM(Sales[SalesAmount])
VAR LastYearSales = CALCULATE(SUM(Sales[SalesAmount]), DATEADD(Dates[Date], -1, YEAR))
RETURN
IF(
ISBLANK(CurrentYearSales) || ISBLANK(LastYearSales),
BLANK(),
DIVIDE(CurrentYearSales - LastYearSales, LastYearSales, 0)
)

Hope it works, 

else please share sample data

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Shineccx007]

hello!

I tried to use the DAX and it worked in Matrix chart.

When I change the chart to graph, something wired happend. Screenshot as below.

And I just wanted the graph show the 2024/2023 Yoy%. It seems showing the total and I don't know how it was calculated.

Is there a way I just show the line yoy% on the data 2024/2023? Thanks!