Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Default Line Chart View Centered on Current Date

I have a line chart showing values over time. By default, the chart always opens at the earliest date. I’d like it to automatically focus around the current month (e.g., April 2025) when the page lo...
  • v-echaithra's avatar
    1 year ago

    Hi  Anonymous ,

    Thanks for posting in Microsoft Community.

    You can use a Relative Date filter to automatically focus the chart around the current date:

    1. Add a slicer to your report using the date field.

    2. Change the slicer type to "Relative Date."

    3. Configure it to show values such as in the last 6 months or any time range you prefer.

    This will dynamically adjust the chart to always focus around the current date when the report loads.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

    Regards,
    Chaithra E.