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

Join 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.

Reply
ravi_raval
Regular Visitor

How can I set custom date filter on line chart for comparison in Power BI?

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.

ravi_raval_0-1711002758026.png

But, when I select the date as per the below SS the comparison line would not work.

ravi_raval_1-1711003028611.png

 


Could you please help or guide me to fix this issue?
Thank you in advance.

Regards,
Ravi Raval

4 REPLIES 4
ravi_raval
Regular Visitor

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

danextian
Super User
Super User

hi @ravi_raval ,
A  similar post was made this week.

https://community.fabric.microsoft.com/t5/Desktop/How-can-I-compare-dates-selected-from-two-separate... 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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.

ravi_raval_0-1711015263416.png

I am try to get compare data using date column. please share your best solutions.

Thanks
Ravi Raval

Joe_Barry
Super User
Super User

Hi @ravi_raval 

 

This video should help you.  https://www.youtube.com/watch?v=E1W7vUhPA1I

 

Thanks

Joe




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn


Let's connect on LinkedIn


Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.