web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Dynamics Opportunity K...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Dynamics Opportunity Kanban board view and calculation update

(2) ShareShare
ReportReport
Posted on by DZ-08110320-0 4

Hello Team,

 

Could I update the current view in the CRM Kanban card in Opportunities? I have 3 fields (Owner, Est. revenue and Est. close date).

Can I change e.g. 'Est. revenue' and 'Est. close date' to 'Actual revenue' and 'Event End Date'?

 

The total amount on the top of the board shows the calculation based on 'Est. revenue', can it be changed to show the total of 'Actual revenue'?

 

Can I do it somehow without buying a plugin? If no, are you planning to increase the functionality of Kanban in the nearest future?

 

Thank you,

Dimitri

Categories:
Dynamics 365 Sales
I have the same question (0)
  • Suggested answer
    Vahid Ghafarpour Profile Picture
    Vahid Ghafarpour 12,133 Super User 2025 Season 2 on at
    You can update the fields displayed on the CRM Kanban card for Opportunities
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 2,351 Super User 2025 Season 2 on at

    As of now, the native Kanban view functionality for Opportunities in Dynamics 365 Sales is fairly limited in terms of customization. Here’s a breakdown of what you can and cannot do with the Kanban view based on the current out-of-the-box features, as well as potential workarounds and alternative options:

    1. Changing Fields Displayed on the Kanban Card

    • Out-of-the-box limitations: You cannot directly customize the fields displayed on the Kanban card in the Opportunity Kanban view. The default fields (like Owner, Est. Revenue, and Est. Close Date) are fixed and cannot be swapped out for other fields without customizations or third-party solutions.
    • Workaround: If showing the "Actual Revenue" and "Event End Date" is essential, a possible workaround would be to:
      • Create a custom view that includes these fields and use it in the standard Opportunity list view, though this wouldn’t have the Kanban layout.
      • Use Dashboards or Power BI reports: If you need more flexible views with alternative field display and total calculations, consider building a custom dashboard or Power BI report. These can mimic a board layout in some ways and provide much more flexibility with which fields are shown.

    2. Changing the Total Calculation to "Actual Revenue"

    • Out-of-the-box limitations: The Kanban board’s top-level calculation aggregates Estimated Revenue by default, and this cannot be changed to sum up another field like "Actual Revenue" using the native Kanban settings.
    • Workaround:
      • Create a calculated field or custom roll-up field in your Opportunity entity to dynamically calculate totals based on "Actual Revenue" if your business logic allows it.
      • Alternatively, you could use Power BI or Dynamics 365 Dashboards to create a more customized view with total calculations based on "Actual Revenue" instead of "Est. Revenue."

    3. Options for Expanding Kanban Functionality Without a Plugin

    • As of now, there is no built-in way to fully customize the Kanban view for Opportunities in Dynamics 365 Sales without a third-party plugin.
    • Microsoft has not announced any upcoming enhancements to Kanban views specifically, but Dynamics 365 features are updated regularly, so it’s worth keeping an eye on the Microsoft Release Plans. You can view these at the Dynamics 365 Release Plan website, which provides information on upcoming features.

    4. Alternative: Third-Party Solutions

    • There are several third-party solutions on AppSource that enhance the Kanban functionality, such as Kanban Board by Inogic or Kanban Board by Maplytics, which allow more customization options for cards and summaries.
    • These solutions generally come at an additional cost, but they can provide the flexibility you’re looking for in terms of changing the fields displayed on cards and adjusting the revenue total calculation.

    Summary

    Unfortunately, without using a plugin, you’re limited to the default fields and aggregation options on the Kanban view in Dynamics 365 Sales. If flexibility on the Kanban board is critical to your processes, consider evaluating third-party solutions or using dashboards/Power BI for custom visualizations and calculations.

  • Inogic Profile Picture
    Inogic 703 on at
    Hi Dimitri,
    Kanban view in Dynamics 365 CRM is a helpful visual tool, but its native customization is limited. Let’s walk through your queries and explore possible options.
    1. Can You Change the Fields in the Kanban Card?
    As of now, you cannot customize fields displayed on Kanban cards (e.g., replacing Est. Revenue with Actual Revenue or adding Event End Date).
    • The card layout is hardcoded by Microsoft.
    • No options exist in form customization, view configuration, or app settings to modify this.
     Official Microsoft Documentation
    2. Can the Board Total Be Based on Actual Revenue?
    Currently:
    • The total amount shown at the top of each pipeline stage is calculated using Est. Revenue only.
    • This logic is not configurable through the UI or backend; no way to switch it to Actual Revenue or any other field natively.
    3. Native Workarounds (Without Plugins)
    While direct customization isn’t possible, here are some alternative approaches that don’t require third-party solutions:
    •  Dashboards/Charts: Create dashboards showing totals for Actual Revenue or Event End Date grouped by stage.
    • Custom Views: Filter or sort by desired fields, though this won’t reflect visually in Kanban.
    These options won’t replicate the Kanban board but can serve similar visibility and reporting needs.
    4. Need True Customization? Try an Advanced Kanban Tool
    If you’re looking for full control over how your opportunities are visualized and managed in a Kanban-style view, consider using an advanced solution like Inogic’s Kanban Board for Dynamics 365 CRM.
    With Inogic’s Kanban Board, you can:
    • Customize the card layout: Choose which fields appear on the Kanban cards, for example, show Actual Revenue, Event End Date, Owner, or even custom fields.
    • Define your swim lanes: Group records by any field (not just status), such as Territory, Owner, Industry, or Priority.
    • Configure stage-wise aggregate totals: Display totals based on any numeric field, like Actual Revenue, Quantity, or Custom Budget Fields.
    • Enable drag-and-drop updates: Move records between stages and automatically update the underlying status or field values.
    • Use with any entity: Works not just with Opportunities, but also with Leads, Cases, Custom Entities, etc.
    • Apply conditional formatting: Highlight cards using color codes based on field values like priority, SLA, or due dates.
    There are other features too of Kanban Board that can help you in customizing your CRM interface.
    5. Is Microsoft Planning Enhancements?
    As of the latest release, Microsoft hasn’t announced native support for field-level customization or aggregation changes in the Kanban board. Keep an eye on the Dynamics 365 Release Plans for future updates.
     
    Thanks,
    Sam

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 81 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans