Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello,
I have created a line chart to compare the previous period's data and it's working fine for the same date period for the current date and compare date. but when I select a different date period it's not working to compare data. for example, if I have to select date as per the below SS count shows as per my requirement working fine.
But, when I select the date as per the below SS the comparison line would not work.
Could you please help or guide me to fix this issue?
Thank you in advance.
Regards,
Ravi Raval
Hey Thanks, Joe for your quick reply.
As per your suggestion, I can do that I can create it for the same period comparison, but my second requirement as per the screenshot is not in your suggested video.
I will be happy if you can send more vedios or suggession to solve my issue Thanks once Again.
Thanks
Ravi Raval
hi @ravi_raval ,
A similar post was made this week.
Thanks @DAXJutsu.
Yes, it works for the category but I am tired of the date column. I can see the data for the trend line only for date not for comparison date.
Below is the screenshot for your referance.
I am try to get compare data using date column. please share your best solutions.
Thanks
Ravi Raval
Hi @ravi_raval
This video should help you. https://www.youtube.com/watch?v=E1W7vUhPA1I
Thanks
Joe
Proud to be a Super User! | |
Date tables help! Learn more
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 38 | |
| 31 | |
| 27 | |
| 26 |