cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mto85 Frequent Visitor
Frequent Visitor

comparing two time periods on a single visual

Hi I am trying to compare two time periods in the same visual on Power BI (eg. 31/12/2015-31/12/2018 vs 31/12/2019-31/12/2022).

I would like to replicate these types of charts (note it's a growth rate):

Untitled.png

I found the following post which sounds helpful:

https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/

This is how my model looks:

 

Untitled 2.png

 

However it's not working.

1) When I link 'Period' table with 'Previous Period' table I lose data hierarchy in 'Period' table so all the analysis I built before are no longer working.

 

2) I get an error when I try to create 'Previous Level YoY%' in DF_ANNUAL

 

Any suggestions?

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
amitchandak Super Contributor
Super Contributor

Re: comparing two time periods on a single visual

Please refer, if this can help. There are two ways. For the second one, the link is given in the article

https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613

View solution in original post

4 REPLIES 4
PaulDBrown Senior Member
Senior Member

Re: comparing two time periods on a single visual

@mto85 

It sounds like the second period table should be unlinked. Ie independent from any tables. 

You create new measures which calculate the output based on the dates selected in the second date table and include a slicer from the second date table. You may have to include an ALL(first date table) filter in your second measures to remove filters from the first date table in the calculations.

Sorry if I can’t be more specific but I’m not in front of a PC to check things out.

amitchandak Super Contributor
Super Contributor

Re: comparing two time periods on a single visual

Please refer, if this can help. There are two ways. For the second one, the link is given in the article

https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613

View solution in original post

mto85 Frequent Visitor
Frequent Visitor

Re: comparing two time periods on a single visual

@amitchandak thank you! in the end this solution worked well!

mto85 Frequent Visitor
Frequent Visitor

Re: comparing two time periods on a single visual

@PaulDBrown thank you for your suggestion! In the end I made this following the link that ChandakAmit sent 

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 6 members 1,668 guests
Please welcome our newest community members: