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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
gfdytr4
Helper I
Helper I

Filter graph for previous 6 months and next 6 months

I need my graph to display previous 6 months and next 6 months. The graph is counting how many people joined a project within a month and how many leave. Therefore i have 2 dates connected to my DimCalander and use USERELTATIONSHIP in my measures to count joiners and leavers. 

 

I have tried adding the date twice in the filter pane and selecting next 6 months and last 6 months but this gives a blank visual. 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

I have solved a similar problem in the attached PBI file.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

I have solved a similar problem in the attached PBI file.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-tianyich-msft
Community Support
Community Support

Hi @gfdytr4 ,

 

This is not clear to me. Can you provide a sample that maps your data model?

 

Best regards,
Community Support Team_ Scott Chang

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors