Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
@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.
@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
User | Count |
---|---|
15 | |
13 | |
12 | |
10 | |
10 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
10 |