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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
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.