Forum Discussion
Filter X axis values in Line Graph
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!
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.
2 Replies
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.
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.
