Forum Discussion
Dynamic X Axis - Selected Start Date
Hi,
I have a line chart which uses a measure that is able to dynamically switch based on the users' selected date as the start date. My dates/data is monthly. I want the x axis to change with the selected start date . For example, if the user selects March 2014, I only want the x axis to display dates greater than or equal to March 2014. My line should update fine as it does now, just need to exlude those prior dates and I cannot figure out the DAX for it.
Thank you for the help!
Hi, erikzimm
You can try the following methods.
Measure = IF(SELECTEDVALUE('Date'[Date])=BLANK(),1,IF(SELECTEDVALUE('Date'[Date])<=SELECTEDVALUE('Table'[Date]),1,0))Is this the result you expect? Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi,
Maybe you could try this?
Measure =
VAR _selectedDate = MINX('DateTable', 'DateTable'[Date])
RETURN
CALCULATE(
SUM('DataTable'[Value]),
'DataTable'[Date] >= _selectedDate
)The selecteddate variable is the minimum (or selected) date filtered by your slicer. So, if your user selects February on the slicer, the measure above will only include data greater than or equal to that date.
Hi, erikzimm
You can try the following methods.
Measure = IF(SELECTEDVALUE('Date'[Date])=BLANK(),1,IF(SELECTEDVALUE('Date'[Date])<=SELECTEDVALUE('Table'[Date]),1,0))Is this the result you expect? Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
