Solved: Filter X axis values in Line Graph

Anonymous · ‎07-05-2019

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 · ‎07-05-2019

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.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

MattAllington · ‎07-05-2019

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.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

v-frfei-msft · ‎07-08-2019

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.