Filter X axis values in Line Graph

[Anonymous]

Hey guys,

Is is possible to filter out the X axis by values in a Line Graph?  I have 3 values, but I want to be able to filter out the values by their own Date, currently they all end at March 2019.  I would something like: (Values A ends at Jan 2019, Values B ends at November 2018 and Values C ends at August 2018).  Is this only possible through the equation of the values itself?

Thanks!

[MattAllington · Accepted solution]

You would need to write a DAX measure that senses the date and returns a value (or not) based on that date. I recommend setting up a matrix while you write the measure. It helps you “see” the problem like and Excel problem. 

[v-frfei-msft]

Hi @Anonymous ,

1 To create a date table as below and insert a calculated column in it. After that , we can create relationship between it and the fact table.

date = CALENDARAUTO()

YM = FORMAT('date'[Date],"yyyymmm")

2. Then we can creater a line visual as below.