Others

How to Customize Dynamics 365 Opportunity Kanban Fields and Totals

Maira Mehtab Sep 27, 2026 869 views

Question details

Users want to replace default fields like estimated revenue and close dates with custom metrics such as actual revenue and event end dates on Dynamics 365 Opportunity Kanban cards.

Product: Dynamics 365
Device & OS: not provided
Scenario: Customizing Kanban board cards and aggregation totals for Opportunity tracking in the CRM.
Observed behavior: The Kanban board displays default estimated revenue and close dates, which need to be replaced with actual revenue and event end dates.

Before you start

Ensure you have the necessary system administrator or system customizer permissions in your Dynamics 365 environment before attempting to modify entity views and Kanban settings.

Solution 1Recommended

Consult the Dynamics 365 Community for Configuration Guidance

Because customizing Kanban card fields and aggregation totals is a backend Dynamics 365 CRM configuration, the best approach is seeking guidance from dedicated Microsoft Dynamics specialists.

The customization of Opportunity Kanban fields and board totals is entirely handled within the Dynamics 365 or Power Apps admin center. It is not a Microsoft Office issue.

Currently, standard out-of-the-box Kanban controls may have specific limitations on which fields can be aggregated (such as being locked to Estimated Revenue). You may need to consult the community on building a custom Power Apps Component Framework (PCF) control to achieve full customization.

Visit the Dynamics 365 Community

Navigate to the official Microsoft Dynamics 365 Community website and search for existing threads on Kanban customization.

Post Your Specific Requirements

Submit a detailed question explaining your need to replace estimated revenue with actual revenue and close dates with event end dates on the Kanban cards.

Consult a System Customizer

Work with your internal Dynamics administrator to check if modifying the 'Opportunity Kanban View' columns in the Power Apps maker portal partially achieves your goal.

Limitation Note: Standard Kanban aggregation fields in Dynamics 365 are often hardcoded to default financial fields. Full replacement might require advanced development rather than simple UI toggles.

Free Microsoft Office alternative

Manage Your Exported CRM Data with WPS Office

While Dynamics 365 manages your backend CRM pipelines, you often need to export opportunity data to spreadsheets for deeper analysis. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your reporting and document creation needs.

1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your computer.
2. Export CRM Data: Export your Opportunity records from Dynamics 365 into an Excel (.xlsx) or CSV format.
3. Open and Analyze: Launch WPS Spreadsheet to seamlessly open your exported data and build pivot tables to track actual revenue.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint formats.Easily open, format, and analyze exported Dynamics 365 Opportunity data.Lightweight software that loads quickly on Windows, Mac, and Linux environments.Familiar tabbed user interface ensures a seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Can I easily change the aggregation field on the Dynamics 365 Opportunity Kanban board?

By default, the Opportunity Kanban board aggregates the 'Estimated Revenue' field. Modifying this to 'Actual Revenue' often requires advanced customization, as standard settings restrict altering the main aggregate field.

How do I change the fields displayed on a standard Kanban card?

Kanban cards typically display fields based on the specific view selected (e.g., 'Open Opportunities'). Administrators can edit this view in the Power Apps customization menu by adding or removing columns like 'Event End Date' to update the information visible on the card.

Is Dynamics 365 Kanban customization related to Microsoft Office?

No, configuring Dynamics 365 Kanban boards is managed within the Dynamics 365 or Power Apps environment. It is a CRM-specific configuration and does not involve troubleshooting or modifying Microsoft Office client applications like Excel or Word.

Office Quick Solutions