The alert attribute in the "sequence" of a dashboard in a bi system can be manually populated with fixed values, or you can set the alert range from the data set to enable dynamic alerts. Where the "range" property is manually entered a fixed value should be a percentage (0-1), while the drop-down selection of the binding column value is numeric. The "Color" and "text" can also be taken from the dataset, and when the attribute "sequence-range-text" is checked, the "text" value in the "range" will be used instead of the scale value.
For example, to set up a dashboard with a three-segment warning range, we need to specify two thresholds and 3 warning colors. and replace the scale value as "poor, good, excellent" three kinds of values.
The contents of the dataset are shown in the following table:
<ignore_js_op>
1, the instrument panel binding Revenue column, and the "warning" attribute for the following settings. The effect is as follows:
<ignore_js_op>
2, you can see the scale of the instrument panel, and our threshold range does not correspond. We do the following:
(1) Turn off the display of the scale
<ignore_js_op>
(2) In the warning, tick "text", set the custom text instead of the scale value
<ignore_js_op>
The final effect is as follows
Power-bi Dashboard for dynamic warning