Data no appear in the Line and clustered column chart

[XaviOV]

Hi there,

I have a "Line and clustered column chart", and have filtered it for the current year.

The problem is that the data I put on the line is calculated for last year, and does not appear on the display. How could I visualize in the "X" line of the visualization the values in columns and in the same "X" axis the data would appear in lines of the values calculated from a year ago in that same period.

Regards,

Xavi

[Anonymous]

Hi @XaviOV ,

Sounds that you need a calendar table.

https://powerbi.tips/2017/11/creating-a-dax-calendar/

Then use the date field of calendar table as the X line.

Thus you will need to modify your formula.

If you can show your formula with some sample data to us, we might help you do that.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

Hope you are using date calendar and plotting axis from the calendar columns only. You can try ytd or trailing year measure or sameperiodlastyear

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"12/31"))
This Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD((ENDOFYEAR('Date'[Date])),"12/31"))

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Last YTD complete Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/