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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

AB
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

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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