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
⋅ 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:
isPercent property set as true:"formats": [{
"name": "percent",
"isPercent": true
}]
"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