Graphing trending

Hi neskiz,

Thanks for reaching out to the Microsoft fabric community forum.

I successfully created a dynamic trend visualization in Power BI using weekly input data. Initially, formatting the data for trend analysis was a challenge, so I want to outline the exact process I used for anyone facing a similar issue.

The original dataset had metrics such as Total source, Total critical, Active, Lost, and Bad setup in rows, with dates like March 7, 2025, and March 14, 2025 as column headers. To make this data suitable for trend charts, I imported it into Power BI and used Power Query to unpivot the date columns. This transformed the data from a wide to a long format, placing each date into a new Date column and corresponding values into a Metric Value column, while keeping metric names in a single Metric column.

This setup makes tracking changes over time straightforward, even across multiple KPIs.

With this structure, I built a line chart the X-axis is Date, the Y-axis is metric values, and the Metric column serves as a slicer to compare or isolate metrics. The report is now highly scalable, automatically updating as new weekly data is added.

This format also works well with clustered column or combo charts for visualizing multiple metrics. I’ve validated it with metrics like Overall Health %, Lost, and Active, and the week-over-week trends are clear.

This approach delivered excellent results, and the Power Query transformation was essential. I’m confident this method will help others streamline their reporting process.

Please find the attached pbix file for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Tejaswi.
Community Support