asked on June 23, 2022
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
⋅ June 24, 2022
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
⋅ July 5, 2022
Hello, Craig!
Our team is wondering whether you had time to try combining Flexmonster's isPercent: true format with cube formatting.
Please let us know whether it helped to resolve the issue.
Best Regards,
Maksym
⋅ July 12, 2022
Hi, Craig!
We would like to know whether you tested the suggested solution for displaying percentages on charts.
Looking forward to hearing your feedback.
Best Regards,
Maksym