Using the ValueBar plugin

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.

valuebar

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).

vb-cell-explained

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

Example

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' />"

Leave a Reply