cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Change of dates with slicer selection

Hi Guys,

 

Here is my problem.

I have a line graph with last 6 months data which is default, now when I select July automaticall the line graph should show past 6 months from July, simillary if I select May the graph automatically move to 6 months past from may. I should not consider the month I selected in the graph only the past 6 months from the month I selected.

 

 

Thanks in advance.

3 REPLIES 3
Super User IV
Super User IV

@Drake023 , Create a column like this in you date table and use that as filter

 

Month Type = Switch( True(),
eomonth([Date],0) <= eomonth(Today(),0) && eomonth([Date],0) >= eomonth(Today(),-6),"Last 6 Month" ,
Format([Date],"MMM-YYYY")
)



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

 This may not work as today is considered.I want last 6 months based on user selection year and month.

Community Champion
Community Champion

@Drake023 

Make a copy of your dates table and don't create any relationship to it, make sure your have Month-Year Column, you create like 

Month Year = FORMAT('DATE'[Date], "Mmm YYYY")

 
Place that Month Year Field on a slicer for the user to choose, create the measure as

 

Past 6 Months = 
VAR _D = EDATE(MIN('Dates2'[Date]),-6) return
IF( 
    MAX('DATE'[Date]) < _D ||  MAX('DATE'[Date]) > MIN('Dates2'[Date]),
    BLANK(),
    [Total Sales]
)

 


I selected Jan 2017, the chart shows the past 6 months

 

Screenshot 2020-09-23 113902.png

________________________

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

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

YouTube  LinkedIn

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors