Forum Discussion
Line chart showing higher values below lower values
I have a line chart which shows current year vs same period last year, but for some reason, when the value is higher than the current year, the line shows much below the actual value on the chart whi...
Hi QuantumLP ,
Are you able to provide the formula that was created. In my contemporaneous comparisons, it seems to show up fine, here are the formulas I created.
this_year = sum(FactInternetSales[SalesAmount])Previous_year =
CALCULATE ( [this_year], SAMEPERIODLASTYEAR ( M_DimDate[Date] ) )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My formulas are
Sales previous period = CALCULATE([TOTAL Completed Sales],SAMEPERIODLASTYEAR(DimDate[Date]))TOTAL Completed Sales = SUM(ITAD_SP_Remarketing_Sales_Report[Completed_Sales])
Both formatted as currency, however as you can see in the screenshot below, the values do not show correctly in the line graph.
I do have a filter on that visual to be this fiscal year