Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Resolver I
6 years ago
Solved

Line Chart, with comparison time

Hello.  I have a Line chart, showing pageviews over time.   I want to add a second line, comparing the date period chosen to the previous period. Is there an easy way to do this?
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Unicorn_Tech you need to set relationship between date table and your original table and then you can use parallelperiod function as described in the link.

     

     

Unicorn_Tech's avatar
Unicorn_Tech
Resolver I
6 years ago

v-deddai1-msft parry2k , I really appreciate your help here.

I have my seperate date table.  I have marked it as a date table.  I have set up a relationshipt between the Date table (Date) to my data table with page views (Date.)

I don't understand how now to calculate a parallel period.  Is this done in a table, an extra column?  Is this done in the reporting view?

My visual is a line chart that shows page views for the past 30 days.  I am now using the field of date from the date table, and the page views column from the data table.

How can I now show a seperate line, with the parallel period.

I appreciate the help - I am learning!

Unicorn_Tech's avatar
Unicorn_Tech
Resolver I
6 years ago

Hello.  Based on internet links, this is what I tried to do, inside my date table:

Date =
VAR __dates = CALENDARAUTO()
RETURN
ADDCOLUMNS (
__dates,
"Year", YEAR ( [Date] ),
"Month Number", MONTH ( [Date] ),
"Month Name", FORMAT ( [Date], "MMMM" ), --use MMMM for full month name, January instead of Jan
"Month", FORMAT( [Date], "MMM, YYYY" ), --use MMMMM for full month name, January instead of Ja
"Month Sort", FORMAT( [Date], "YYYY-MM" ),
"Quarter", "Q" & FORMAT( [Date], "Q, YYYY" ),
"Quarter Sort", FORMAT ( [Date], "YYYY-Q" ),
"Par", calculate(sum('All Web Site Data'[Pageviews]),'All Web Site Data'[Date],PARALLELPERIOD('All Web Site Data'[Date],-1,MONTH)
)
 
The bold text is returning the same value for each row, rather than returning the total page views for the particular date, in the parallel period.