The ValueBar plugin has the ability to display a percentage value and a bar representing this value within one cell of the data presentation grid.
It can also display a value that is not a percentage to start with and make the bar into a percentage representation of this value, but this requires a maximum value to also be defined.
The following properties can be user to change the behaviour of the plugin.
v - The v property should be mapped to the actual value to be displayed in the cell max - The maximum value if the v value is not a percentage value to start with. prefix - A string that will prefix the value itself. suffix - A string that will suffix the value itself. valuewidth - The width of the value section (default '40px') barwidth - The width of the var section (default '100px') enablenegative - A flag that can be used to turn of the negative portion of the control. (default 'true') positivebarcolor - The color of the positive value bar (default '#3498DB') positivebarbackground - The color of the background behind the positive bar. negativebarcolor - The color of the negative value bar (default '#FF0000') negativebarbackground - The color of the background behind the negative bar. barborderstyle - The box surrounding both the positive and negative bars. Valid values: 'none','hidden','dotted','dashed','solid' and 'double'. Default value is 'solid'. barbordercolor - The color of the box surrounding the positive and negative bars. Default value is '#CDCDCD' . barborderwidth - The width of the border surrounding the positive and negative bars. Default value 'thin' (can be set in pixels too).
How to use the plugin:
- Make sure the plugin is loaded and activated on in your solution. (import it from the Tools – Plugins screen in the designer).
- Create a declared member and define the plugin through the string returned by the declared member
The following is the expression on a declared member used on the column in the report that will contain the valuebar:
<valuebar v=""" + CSTR([Measures].[MyPercentValue]) + """ enablenegative='false' />"