Get Free Trial

Percentages on Charts

Answered
Craig Button asked 5 days ago

When a measure is formatted as a percentage. Line and bar Charts will not use % as the scale but instead use decimals.
The Pivot gets the formatting from an OLAP Cube and this works fine for the grid and pie charts.
It looks like the percent as a format is not being passed to the chart and the format cells menu is also showing Format as percent as false.
Kind regards,
Craig Button
 

1 answer

Public
Maksym Diachenko Maksym Diachenko Flexmonster 4 days ago

Hello, Craig!

Thank you for your question.

Please note that the values on the chart axis are generated automatically, so they are not taken from the cube and, hence, the cube formatting is not applied. To show percentages on the chart axis, we recommend using the number formatting inside Flexmonster. This format will not override the original cube formatting but will be used on the chart axis. 

Here are steps to set the percent formatting:

  • Add format inside the report, with isPercent property set as true:
"formats": [{
    "name": "percent",
    "isPercent": true
}]
  • Apply the format to a specific measure inside the slice:
"measures": [{
    "uniqueName": "[Measures].[Ratio to All Products]",
    "format": "percent"
}]

Check the JSFiddle example: https://jsfiddle.net/flexmonster/s92m1z7x/

Please let us know if this solution works for you.

Best Regards,
Maksym

Please login or Register to Submit Answer