🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Show dimension/label in exported pdf and excel

Thomas Mortensen asked on November 15, 2019

Is it possible to show dimensions/label from a pie chart in export pdf and excel? I have attached a photo pointing at what I would like to be able to see in a PDF and Excel export.

3 answers

Vera Didenko Vera Didenko Flexmonster November 15, 2019

Hello, Thomas,
Thank you for writing to us.
We kindly suggest one of the following ways to include the chart measure and dimension member names in the PDF export:
1) Setting a chart title for the export: https://jsfiddle.net/flexmonster/bL7vz1ux/
2) Specifying a header for the export: https://jsfiddle.net/flexmonster/hqd0yx87/
Please kindly note that when exporting to Excel, Flexmonster is exported as a grid.
In this case, the selected fields are already visible.
Please let us know if you have any questions.
Best Regards,

Jesper Bo Rasmussen December 11, 2019

We have been looking at you example but have a problem.
We use a localization JSON file for danish localizations.
We also use JSON as the format for the data and we use the json metadata to translate the captions as explained here https://www.flexmonster.com/doc/data-types-in-json/
Our problem is that we want to show the translated text and name in the pdf and the excel, but when we inspect the activeMeasure property (see attached file ‘ActiveMeasure.jpg’) we don’t have access to the translated values that is shown in the dropdown (see attached file ‘Chart.jpg’). How can we get the same text as shown in the dropdown?

Vera Didenko Vera Didenko Flexmonster December 12, 2019

Hello, Jesper,
Thank you for reaching out to us. 
We would like to explain that activeMeasure is using the uniqueName property which is different from the caption
Captions allow customizing the way fields are displayed in Flexmonster, but they don’t affect the uniqueName.  
Please consider passing a pre-translated dataset. This way the uniqueName will correspond to your data. 
Here is an example of such an approach: https://jsfiddle.net/flexmonster/Lz8sjbnf/ 
Please let us know if this works and if you have further questions. 
Best Regards, 

Please login or Register to Submit Answer