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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Amardeep100115
Post Prodigy
Post Prodigy

Display previous month data

Hi

 

I wish to have previous month data even if current month  is not selected in slicer. and then the visual should change according selections month. also another visual shows data for current data.

 

Please help

Amardeep Bhingardeve
3 REPLIES 3
v-lionel-msft
Community Support
Community Support

Hi @Amardeep100115 ,

 

Please refer to the links.

Display Last N Month and Selected Month data using Date Dimension in Power BI 

Display Last N Months & Selected Month using Single Date Dimension in Power BI 

If this is not what you want, please refer to @Fowmy ‘s suggestions.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Amardeep100115 , refer my two videos. For that you need stop you calendar at this month

https://www.youtube.com/watch?v=OBf0rjpp5Hw

https://www.youtube.com/watch?v=j0ug-XQgZtg

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Fowmy
Super User
Super User

@Amardeep100115 

The given information is not enough to understand your question, please provide sample data and the expected output.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 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.