Have YTD and months in same bar chart

[Anonymous]

I am trying to replicate an excel chart into Power BI. I was wondering if it was possible to have YTD in Line, and months in bar chart? In addition, can I have last year avg count of incidents and present year YTD?

[amitchandak]

@Anonymous , The bar, and line are easily possible using your measure say M1

M1 as bar

calculate([M1], datesytd(Date[Date])) //With help from date table

But for the other two, you have referred trick

Power BI - Show Grand total row or Avg Grand total row in Visual: https://youtu.be/OSwRZ4GUhxc
https://medium.com/@amitchandak/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463behttps://youtu.be/OSwRZ4GUhxc

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
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 :radacad sqlbi My Video Series Appreciate your Kudos.