Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic x-axis min/max range

Hello,   I have a time-series graph and my goal is to have the x-axis min and max dates adjust automatically based on the slicer selected value's start and end dates.   1. Sample data/scenario: ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You may create a measure to filter the dates for x-axis. For example:

     

    IF(SELECTEDVALUE(axis_dates)>=MIN(slicer_dates)&&SELECTEDVALUE(axis_dates)<=MAX(slicer_dates),1,0)

    Then put this measure to visual level filter that filter measure = 1.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

You may create a measure to filter the dates for x-axis. For example:

 

IF(SELECTEDVALUE(axis_dates)>=MIN(slicer_dates)&&SELECTEDVALUE(axis_dates)<=MAX(slicer_dates),1,0)

Then put this measure to visual level filter that filter measure = 1.

 

Best Regards,

Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous Thank you.