Forum Discussion
Anonymous
3 years agoNot applicable
Year on Year Comparison with a Line Chart
Hello! What I want to do is to plot one year's worth of data vs another year on a line chart. My data is set up as a Value per Month. So in the Month column you have dates, assigned to the first...
amitchandak
Super User
3 years agoAnonymous , I think you need this
Power BI Abstract Thesis: How to use two Date/Period slicers
Other TI can help
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Anonymous
3 years agoNot applicable
Hello amitchandak! Thank you for this. If I understand correctly, the approach is to to create a separate Date table and use that for one of the slicers?