Forum Discussion

Anduve11's avatar
Anduve11
Frequent Visitor
8 years ago

Line and Column Chart - Current Year and PY Problem with end-of-month transition to first-of-month

I have a Line and Column Chart visual on my report.  The column data show's current year visits for the last week and the line chart shows prior year visits during the same time period last year.  On the x-axis I have Day-Of-Month and the y-axis is the sum of total visits.  During the middle of the month the visual looks great.  But at the start of the month the visual doesn't work(see image below).  Any ideas on how to avoid this?  Do i need to do something with the sort order or is it a configuration thing?

 

In my date table I have the following measures created to pull last weeks data and PY last week:

 

Last_Week = Dim_Date[Date] >= Today()-8
PY_Last_Week = DIM_DATE[DATE] >= TODAY()-373 && DIM_DATE[DATE] <= TODAY()-366

And then in my visits table I have these measures created:

 

Week_TotaL_Visits = CALCULATE(SUM(VW_VISITS[TOTAL_VISITS]),DIM_DATE[Last_Week] = TRUE())
PY_Week_Visits = CALCULATE(SUM(PY_VISITS[TOTAL_VISITS]),DIM_DATE[PY_Last_Week] = TRUE())

This is how the visual should look when working:

Middle of Month

This is how the visual looks at the beginning of the month:

1 Reply

  • Hi @Anduve1,

    Instead of calculating the py week try to use the SAMEPERIODLASTYEAR.

    Not on computer right now to simulte the measure.

    Regards
    MFelix