Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |