Continuous Trend Graph

superjermsss — Mon, 26 Jan 2026 04:41:33 GMT

Hello Team,

I am currently working on updating our KPI for January 2026. However, I realized that the graph representation is not continuous. For example, if I selected year 2024 and 2025, it only shows Jan to Dec in the graph, and I think the KPIs are average for both months in these years. I like my graph to show it continuously. I want it to show as Nov 2024, Dec 2024, Jan 2025, Feb 2025 and so forth. What do I need to do and update?

Thank you!

Re: Continuous Trend Graph

Vegar — Mon, 26 Jan 2026 06:01:57 GMT

I your graph you've two dimensions year and month.

In order to get a simgle line showing Jan 2024, Feb 2024,...,Dec 2025 you would need to construct such a dimension and replace it with the two current dimensions.

1. Create a new dual dimension. I would do it in the load script (master calendar) like this monthname(my_date_field) as [Month year]

2. Then remove the Year and Month from the line chart

3. Add the new [Month year] dim to the line chart. (Make sure the chart is sorted by your new field numerical and not alphabetical, nor by measure value)

topic Continuous Trend Graph in Reporting Service & Alerting

Continuous Trend Graph

Re: Continuous Trend Graph