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 20...
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.
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.
