Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
pbagalore
New Member

Previous Period Sales vs Current Period Sales dynamic with Filtering Latest Date

Hi, I am looking for a simple Previous Period (Any Previous Date) Sales to be compared in any one viz (Trend Charts or Bar Charts or Matrix) with Current Period (Latest Available Date), it should work dynamically with a Global Filter Date on selecting Latest Date and any other related filter within data.

 

Thanks in Advance.

2 REPLIES 2
amitchandak
Super User
Super User

@pbagalore , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Date Range Vx Date Range -https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 

Using time intelligence

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...


Appreciate your Kudos.


Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

@amitchandak, We have also received this requirement from client. 

 

We have to show sequential growth in bar graph showing 12 quarters in X-Axis. For example, if we have selected FY20 and Q4 then X-Axis will show data from FY18 to FY20 and once global date filter is changed to FY19, it will show data from FY17 to FY19. Due to this global filter, i am unable to create any calculation for sequential growth. Can you please help me out on this? 

 

Thanks,

Paras Sachdeva

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.