Use Color Codes from Option Sets in both Dynamics 365 charts and Power BI

A really good blog which we can use to control the chart colors in Power BI based upon the option set color codes configured in Dynamics. 

Using the blog, we can set the color each record will occupy in a table view in Power BI based upon the value in its corresponding option set field.

crm chart guy

Option Sets in Dynamics 365 has a setting for each value to specify a color code. This color code is used in the new Unified Interface in the entity specific dashboards. This is a welcome addition as it makes it more easy to persist colors to a specific value and have it be consistent throughout the charts and visuals.

option set color code to UI entitiy dashboard

With the August 2018 release of the Power BI Desktop client, we can now also do conditional formatting based on a field with a color code in Power BI reports.

power bi option set color value

Since we can query option sets directly, and get the color code into the Power BI dataset, we can now use the same color scheme more easily between the two solutions. As the option sets are queried, any updates to values, labels, and color codes in the option set, will automatically update on the Power BI side as well.

For querying…

View original post 59 more words

CDS Analytics Dashboard replacing Organisation Insights

Just wanted to share a feature in Power Platform Admin center which is replacing the analytics provided by Organisation Insights Solution. The organisation insights solution has now been deprecated and is being replaced by the CDS Analytics. More information is provided in the following link


Book First Look – 70 483 Programming in C#

Happy to release the first look of the book 70 -483 Programming in C#. Hopeful about the official release of the book in September this year.

Very thankful to my co-author Madhav and the entire team of Packt for there help during the making of this book. Also thanks to all my colleagues in KPMG for supporting me in this endeavour.