Forum Discussion

id013's avatar
id013
Helper V
5 years ago
Solved

Comparing Volume over Multiple Years

Hi,   So I'm working on a visual that compares sales volumes from the current year and compares it to the same exact period last year. The way I wanted to do it is that the date slicer on the visua...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi id013 ,

     

    Or like this, compare the values of different years in the same month instead of being accurate to each day. In doing so you can create a month slicer.

    Year Over Year (YOY) Comparisons in Power BI - YouTube

     

    Best regards,
    Lionel Chen

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

lbendlin's avatar
lbendlin
Super User
5 years ago

Absolutely.  You can create an additional calculated column that strips out the year part of your dates, and then use that column for your X axis. (Or you already use a proper calendar table which gives you that functionality for free)