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.
How to achieve this in Power BI?
That would be a huge assitance if anyone could help me.
Go to Solution.
Hi @bekzod ,
You couldn't do it directly in Power BI.
You could create two new columns.
7 days =
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.
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!