Forum Discussion

erikzimm's avatar
erikzimm
Regular Visitor
2 years ago
Solved

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 th...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.