How to add Custom Stacked Column Chart and Change the Color Based on Threshold Line

In this article, we will learn how to change the color of a stacked column graph based on conditions, such as when a threshold has been breached. We will also discuss enabling advanced formatting for stacked columns and changing the shape of a marker in a line graph.

Steps to Add a Stacked Column Chart Custom Widget

1. Download the below custom widget. This widget will be in the .bicw file format

2. Navigate to the Settings page in Bold BI.
3. Select the Widgets tab.
4. Click the Add New Widget button.
5. Browse and select the downloaded custom widget (.bicw) file to add it.
   
   
   
   You can find the added widget in the Custom widgets section.
   
   

Changing the Color of a Stacked Column Graph

1. In the custom widget, configure the threshold value or line value in the Value for Line(s) section.

2. The configured line will pass through the chart and appear in the same color.

3. To change the color, use the following property:

Enabling Advanced Formatting for Stacked Columns

To enable advanced formatting for stacked columns, follow these steps:

1. Navigate to the Advanced Formatting section in the custom widget settings.

2. Enable the desired formatting options, such as changing the color of the stacked column based on conditions.

Changing the Shape of a Marker in a Line Graph

Currently, there is no built-in feature to change the shape of a marker in a line graph. However, you can explore third-party libraries or custom solutions to achieve this functionality.

Additional References

• Custom Widget Documentation
• Advanced Formatting Options
• Third-Party Libraries for Graph Customization