Small and medium business | Business Central, N...

Business Central Chart Visualisations - Timeline of Events

(6) Share

Report

Posted on by Y_A

367

Hi all,

I am looking for suggestions with regards to creating visualisatons in Business Central, if possible.

I have the below dataset in a table in Business Central;

Record ID	Date	Event
123456	01/01/2024	Create
123456	02/01/2024	Update - Name
123456	03/01/2024	Upate - Age
123456	04/01/2024	Deleted

I would like to show the above data in a timeline manner, i.e. in a way that the user can see the changes overtime that the record went through.

(Below timeline is just an example to render the idea of what we're looking for - we're open to options).

We have tried to look into the available charts that can be created via AL but seems like none of them can be used to render the idea - https://learn.microsoft.com/en-us/dynamics365/business-central/application/system-application/enum/system.visualization.business-chart-type

Any ideas how this can be achieved?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Khushbu Rajvi. 19,017 Super User 2025 Season 2 on at

Like (2)

Report

Business Central Chart Visualisations - Timeline of Events

If this helps: https://learn.microsoft.com/en-ca/dynamics365/business-central/ui-excel-report-layouts?tabs=any-report

Was this reply helpful? Yes No
Vahid Ghafarpour 11,930 Super User 2025 Season 2 on at

Like (1)

Report

Business Central Chart Visualisations - Timeline of Events

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No
Gerardo Rentería Ga... 22,566 Most Valuable Professional on at

Like (2)

Report

Business Central Chart Visualisations - Timeline of Events

Hi, good day
I hope this can help you, and give you some hints.

Create Charts with Business Central and Azure OpenAI - ML blog

How to Create and use the Control Add-In in Business Central - Ivan Singleton

Visual Scheduling Add-in Developer Toolbox| Microsoft Dynamics 365 BC

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 12,116 Super User 2025 Season 2 on at

Like (2)

Report

Business Central Chart Visualisations - Timeline of Events

Hello,

You can Customize the Report as per your Requirement OR use the Power BI Report Tool for the same.

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,503 Super User 2025 Season 2 on at

Like (2)

Report

Business Central Chart Visualisations - Timeline of Events

Please try in built Power BI and Excel reporting

https://learn.microsoft.com/en-ca/dynamics365/business-central/manufacturing-analytics-overview

https://learn.microsoft.com/en-ca/dynamics365/business-central/ui-excel-report-layouts?tabs=any-report

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 90,130 Super User 2025 Season 2 on at

Like (2)

Report

Business Central Chart Visualisations - Timeline of Events

Hi, try Power BI reports, for example, the standard can be done like this.

#msdyn365bc #manufacturing #analytics | Kennie Nybo Pontoppidan | 24 comments

In addition, RDLC should also be able to do this, as long as the number of points is fixed and does not exceed the pre-set maximum value. You can use the following conditions to set whether lines and points are displayed.

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/expression-examples-report-builder-and-ssrs?view=sql-server-ver16#DecisionFunctions

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Holly Huffman 6,520 Super User 2025 Season 2 on at

Like (2)

Report
Business Central Chart Visualisations - Timeline of Events

Good morning, afternoon, or evening :) depending on your location!

Creating a timeline visualization in Business Central for tracking changes over time can be challenging with the standard chart types available via AL. However, here are some suggestions to achieve your goal:

Custom Chart Development: You can use the Business Chart Control Add-In to create a custom chart. This involves defining a setup table, setup page, management codeunit, and chart page. The chart can be tailored to display events in a timeline format. You can find more details about this approach here.

Power BI Integration: Export the dataset from Business Central and use Power BI to create a timeline visualization. Power BI offers advanced charting capabilities, including timeline charts, which can effectively display the progression of events.

Third-Party Tools: Explore third-party visualization tools or add-ons that integrate with Business Central. These tools might offer pre-built timeline visualization features.

Custom Page in AL: If you prefer to keep everything within Business Central, you can create a custom page using AL code to display the data in a timeline format. This would require development expertise to design the layout and logic.

Hope this helps some!

Was this reply helpful? Yes No