Color options and create a custom color palette for the Chart Editor in the XrmToolBox

The charts in Dynamics 365 supports four different types of colors and 12 different system color palettes, outside of the custom palette that Dynamics 365 uses by default in its charts. In this video I'll go through how to work with those four different types of colors in the Advanced Chart Editor plugin for the … Continue reading Color options and create a custom color palette for the Chart Editor in the XrmToolBox

Edit Charts in the XrmToolBox for Dynamics 365

For the past months I have been collaborating with Mohamed Rasheed on a plugin for the XrmToolBox. We are pleased to announce that it is now available. The plugin, which can be downloaded from the plugins store is called "Advanced Chart Editor" and it lets you modify the chart XML in Dynamics 365 (and Dynamics … Continue reading Edit Charts in the XrmToolBox for Dynamics 365

Record Specific Power BI Reports in Dynamics 365 (only one click away)

I recently returned from a trip where I traveled around Europe teaching Business Intelligence and Power BI for Dynamics 365 and finished it off with a number of presentations at eXtreme365 in Lisbon. First of all, a huge thank you to all the people who attended my sessions and all the great questions that followed. … Continue reading Record Specific Power BI Reports in Dynamics 365 (only one click away)

Prefilter data for Power BI with OData URLs

When you connect Power BI to Dynamics 365, it pulls all the records from the entities that you have selected. That is generally a good thing, but there are situations where that is very inconvenient. Maybe you are dealing with large datasets, or you need to filter what records are available for security purposes. If … Continue reading Prefilter data for Power BI with OData URLs

Setup the Data Export Service with a Power BI Solution Template

The Data Export Service is a new and exciting service from Microsoft. It is usually referred to in the context of creating SQL based reports on Dynamics 365 data. However, it is lot more than that and can definitely be leveraged for Power BI as well. I will explore that in this blog post and … Continue reading Setup the Data Export Service with a Power BI Solution Template

Power BI and mixed Team/User Ownership in Dynamics 365

In Dynamics 365 it is easy to assign cases, opportunities, etc. to a Team. This is a very convenient feature and when working with the built-in charts and dashboards, all the charts nicely puts either the team or user name on the legend, depending on what type the owner happens to be. However, Power BI … Continue reading Power BI and mixed Team/User Ownership in Dynamics 365

Time to expand the scope of the CRM Chart Guy blog

Dynamics 365 has now arrived, and as any other update to the Dynamics CRM/365 product for the past five years, it pretty much contained zero updates to the built-in charting engine. The good news there is that all of my blog posts from the past five years are still valid and I won’t have to … Continue reading Time to expand the scope of the CRM Chart Guy blog