Formatting BI Publisher chart axis labels to display integers only
Summary:
I am working on a complex report in BI Publisher that is based on uploading an RTF file, and in this chart I need to display only integer numbers on the X-axis.
How i can set up the rtf document to display this format of numbers?
To build the graph i used only the advance tab, using this xml code:
<Graph seriesEffect="SE_AUTO_GRADIENT" graphType="BAR_HORIZ_CLUST"><GraphArea leftMargin="350" bottomMargin="20" /><LegendArea visible="false" /><O1Axis labelsVisible="true" lineDisplayed="false" fontSize="20" tickLabelFontSize="20" labelFontSize="20" textFontSize="20" /><X1Axis labelsVisible="false" lineDisplayed="false" /><SeriesItems><Series id="0" color="#1b365d" /></SeriesItems><LocalGridData colCount="{count(.//D_SELFROLEMODEL[position() <= 5])}" rowCount="1"><RowLabels><Label>Self - Role Model</Label></RowLabels><ColLabels><xsl:for-each select=".//D_SELFROLEMODEL[position() <= 5]" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Label><xsl:value-of select="RESPONSE" /></Label></xsl:for-each></ColLabels><DataValues><RowData><xsl:for-each select=".//D_SELFROLEMODEL[position() <= 5]" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Cell><xsl:value-of select="COUNTRESPONSES" /></Cell></xsl:for-each></RowData></DataValues></LocalGridData></Graph>