About Us
Our Team
Join the Team
News
Business Solutions
Customer Relationship Management
Stakeholder Management
Sales Management
Case Management
Business Intelligence
Member Management
Custom Business Applications
Infinity Support Suite
Migrate from Salesforce
Our Products
Our Work
Blog
Contact Us
Magnetism
About Us
Our Team
Join the Team
News
Business Solutions
Customer Relationship Management
Stakeholder Management
Sales Management
Case Management
Business Intelligence
Member Management
Custom Business Applications
Infinity Support Suite
Migrate from Salesforce
Our Products
Our Work
Blog
Contact Us
    • Formatting (Blank) in Power BI using a Calculation Group

      Colin Maitland, 04 August 2021

      In this article, I will demonstrate a simple method to format ‘(Blank)’ on a Data Card in a Power BI report as ‘0’ or ‘-’ rather than ‘(Blank)’.This image shows a page from a report in Power BI. Notice that the values displayed by the Data Cards for Open Revenue and Due to Close Revenue near the top

      Read the full article here
    • Configure Power BI Line and Stacked Column charts for Targets

      Colin Maitland, 26 July 2021

      In this article, I will demonstrate how to configure a Line and Stacked Column chart in a Power BI report to display Won Revenue and Open Revenue against Sales Targets and Target Remaining for Opportunities from Dynamics 365. This demonstration highlights a useful approach for using this type of cha

      Read the full article here
    • Dynamically setting the Y-Axis on multiple Charts in Power BI

      Colin Maitland, 27 June 2021

      In this article, I will demonstrate how to dynamically align the end value for the Y axis between two corresponding charts in Power BI. This demonstration will use of the example of displaying Won sales versus Lost Sales by Fiscal Quarter.A common approach to comparing values, such as Won Sales vers

      Read the full article here
    • Updating addresses in Dynamics 365 with an embedded Canvas App

      Colin Maitland, 15 June 2021

      In this article I will demonstrate how to update the addresses for a Contact in Dynamics 365 using a Canvas App that is embedded in a Model Driven App Contract.This image shows the embedded Canvas App. The app is displayed on a tab named Addresses on a Model Driven App Contact Form. You learn how to

      Read the full article here
    • Canvas Apps - Formatted Number Text Input and Display Demonstration

      Colin Maitland, 19 April 2021

      In this video blog, I will explain some limitations of using a Text Input control in a Canvas App to enter and display numbers. I will then demonstrate how a Label, Text Input and Timer control may be configured and used together to allow the data entry and display of formatted numeric values in a C

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 8

      Colin Maitland, 02 March 2021

      In my first article of this series, I introduced a demonstration of a custom Power BI embedded Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this final

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 7

      Colin Maitland, 22 February 2021

      In my first article of this series, I introduced a demonstration of a custom Power BI embedded Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this penul

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 6

      Colin Maitland, 16 February 2021

      In my first article of this series, I introduced a demonstration of a custom Power BI embedded Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.The two most

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 5

      Colin Maitland, 22 January 2021

      In my first article of this series, I introduced a demonstration of a custom Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this article I will describe

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 4

      Colin Maitland, 16 December 2020

      In my first article of this series, I introduced a demonstration of a custom Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In a previous article I introdu

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 3

      Colin Maitland, 30 November 2020

      In my first article of this series, I introduced a demonstration of a custom Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this article I will introduc

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 2

      Colin Maitland, 26 November 2020

      In my first article of this series, I introduced a demonstration of a custom Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this article I will demonstr

      Read the full article here

Filter by Category

  • Azure
  • CRM
  • Dynamics 365
  • Microsoft 365
  • Mobile
  • Power Apps
  • Power Automate
  • Power BI
  • Power Platform
  • SharePoint

Filter by Author

  • Adam Murchison
  • Alfwyn Jordan
  • Arthur Mandisodza
  • Calum Jacobs
  • Colin Maitland
  • David Mochrie
  • Dominic Liu
  • Gayan Perera
  • Harshani Perera
  • Isaac Stephens
  • Jaime Smith
  • Jared Johnson
  • John Barrencechea
  • John Eccles
  • Lauren Withers
  • Paul Nieuwelaar
  • Roshan Mehta
  • Roz Millar
  • Ryan Blaikie
  • Ryan Ingram
  • Sarah Coleman
  • Sean Roque
  • Shalane Williams
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
Back to Top
Magnetism Solutions Microsoft Solutions Partner

Our team

Join our team

Our products

Our work / case studies

Sustainability | Privacy Policy | Terms of Use | Trust Center

Power Platform | Power Apps | Power Automate | Pricing | Training

Auckland
26 Greenpark Road, Penrose
+64 9 888 4086

Wellington
Level 13, 57 Willis Street
+64 4 889 4450

Christchurch
Level 1, 293 Durham Street North
+64 3 669 5210

Sydney
Coming soon…
+61 1800 330 955

Thank you! We will be in touch with you soon.

Copyright © 2025 Magnetism Solutions Limited.
All Rights Reserved.