How to replicate comparative, relative line chart as in Google Analytics?

[bekzod]

hi all,

I have a challenge visualizing comparative, relative time period in a line chart.

The line chart I am trying to replicate is already available in Google Analytics (see below). If I choose last 7 days, it shows two lines.

• 1 for last 7 days
• 2nd for 7 days before the last 7 days

How to achieve this in Power BI? 

That would be a huge assitance if anyone could help me.

[v-eachen-msft · Accepted solution]

Hi @bekzod ,

You couldn't do it directly in Power BI.

You could create two new columns.

7 days =
 DATEADD('Table'[Date],-7,DAY)

value2 =
LOOKUPVALUE ( 'Table'[value], 'Table'[Date], 'Table'[7 days] )

Then use line chart to get visual. Set rules in the filter pane. 

You could download my test file and refer to it.