- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
08-26-2024 09:18 AM | |||
05-14-2024 03:55 AM | |||
11-08-2023 01:08 PM | |||
12-10-2018 05:55 PM | |||
01-09-2024 07:56 AM |
User | Count |
---|---|
85 | |
78 | |
41 | |
40 | |
35 |