Reply
erikzimm
Regular Visitor
Partially syndicated - Outbound

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!

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Syndicated - Outbound

Hi, @erikzimm 

 

You can try the following methods.

Measure = 
IF(SELECTEDVALUE('Date'[Date])=BLANK(),1,IF(SELECTEDVALUE('Date'[Date])<=SELECTEDVALUE('Table'[Date]),1,0))

vzhangti_0-1703674545949.png

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.

View solution in original post

2 REPLIES 2
v-zhangti
Community Support
Community Support

Syndicated - Outbound

Hi, @erikzimm 

 

You can try the following methods.

Measure = 
IF(SELECTEDVALUE('Date'[Date])=BLANK(),1,IF(SELECTEDVALUE('Date'[Date])<=SELECTEDVALUE('Table'[Date]),1,0))

vzhangti_0-1703674545949.png

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.

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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. 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)