Forum Discussion

rqh's avatar
rqh
Frequent Visitor
2 years ago
Solved

Line Chart with Current Year and Prior Year values

Hi everyone! My line chart has two lines: one for current year sales (CY) and the other for prior year sales (PY). For the most recent year, CY records stop in May. I would like for the chart to n...
Need Help
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Try this measure

    PY net sales new = if([Net sales]=blank(),blank(),[net sales])

    If this does not work, then share the download link of the PBI file.

garreola's avatar
garreola
Regular Visitor
1 year ago

Hello I have the problem that I need to show the Current Year unitl it now i.e. February

However I need to show Prev Year with all months

 

Cantidad Comprada ThisYEARSelected =
 
IF( ISBLANK( [Cantidad Comprada] ) ,
    BLANK() ,
    CALCULATE( [Cantidad Comprada] ,
        DATEADD( addCalendarioComprasCat[FECHA_COMPRA] , 0 , YEAR ) )
)
 
 
Cantidad Comprada LastYEARSelected =
 
IF( ISBLANK( [Cantidad Comprada] ) ,
    BLANK() ,
    CALCULATE( [Cantidad Comprada] ,
        DATEADD( addCalendarioComprasCat[FECHA_COMPRA] , -1 , YEAR ) )
)
 
I use these formaulas because I'm using a filter selected to show the year the user wans to show
 

 

Thank you