Bind values to a specific color in the dashboard

(0) Share

Report

Posted on by Jayaa E

Hi,

Bind values to a specific color in the dashboard

I need to create a multi-stack bar graph based on the option set values.
Based on the value, the color should be displayed in the bar graph. I had exported the chart and updated the color values in XML. But then, if one of the values is not present in the results, the colors are not displaying properly. I want something like this(if the value is A, the color should be green, if it is B color should be Red, and so on).
I had googled and found a blog where it had mentioned to create dummy condition & records, I do not want to do that as my results would be based on the logged-in user business unit.

Is there any way to achieve the dashboard graph legend color, based on the value?

In case, if it can be achieved through the SSRS report and bind it in the dashboard, is there any way to populate the results based on the
logged in user business unit?

I am using CRM on-prem. Please provide any suggestions for this.