title: Pentaho - How to show complete date in line chart's X axis
body: <p>I'm creating a Pentaho CDE dashboard and I'm having some difficulties in setup how the date is shown in a line chart. The below chart is what I have at this time:</p>
  
  <p><a href="https://i.stack.imgur.com/X2SJt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/X2SJt.png" alt="line chart"></a></p>
  
  <p>As you can see, the X axis has numbers from 1-6, they are months. What I want do is show more information in this axis instead of simply 1, I want show "January / 2013" for example, but I have no idea of how can I achieve this.
  My Mondrian schema for date dimension is this:</p>
  
  <pre><code>&lt;Dimension type="TimeDimension" visible="true" foreignKey="data_id" highCardinality="false" name="Data"&gt;
      &lt;Hierarchy name="data" visible="true" hasAll="true"&gt;
          &lt;Table name="dimensao_data"&gt;
          &lt;/Table&gt;
          &lt;Level name="ano" visible="true" column="ano" type="Numeric" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never"&gt;
          &lt;/Level&gt;
          &lt;Level name="semestre" visible="true" column="semestre" type="Numeric" uniqueMembers="false" levelType="TimeHalfYears" hideMemberIf="Never" captionColumn="labelSemestre"&gt;
          &lt;/Level&gt;
          &lt;Level name="quarto" visible="true" column="quarto" type="Numeric" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never" captionColumn="labelQuarto"&gt;
          &lt;/Level&gt;
          &lt;Level name="mes" visible="true" column="mes" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" captionColumn="labelMes"&gt;
          &lt;/Level&gt;
          &lt;Level name="dia" visible="true" column="dia" type="Numeric" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never"&gt;
          &lt;/Level&gt;
      &lt;/Hierarchy&gt;
  &lt;/Dimension&gt;
  </code></pre>
  
  <p>and this is the MDX I'm using to retrieve data for the chart:</p>
  
  <pre><code>SELECT NON EMPTY {[Measures].[valor]} ON COLUMNS,
  NON EMPTY CrossJoin({[pagamento.forma].[moeda].MEMBERS}, {[Data.data].[mes].MEMBERS}) ON ROWS
  FROM [Vendas]
  WHERE {[Empresa.empresa].[MATRIZ]}
  </code></pre>
  
  <p><strong>NEW INFORMATION</strong></p>
  
  <p>When I use debug mode I can see that Data.data don't comes only with month value and in String format: </p>
  
  <pre><code>[pvc.LineChart                 ]: DATA SOURCE SUMMARY
  ╔═════════╤═════════════════════╤═════════════╤══════════╗
  ║ Name    │ pagamento.forma     │ Data.data   │ valor    ║
  ╟─────────┼─────────────────────┼─────────────┼──────────╢
  ║ Label   │                     │             │          ║
  ╟─────────┼─────────────────────┼─────────────┼──────────╢
  ║ Type    │ String              │ String      │ Numeric  ║
  ╟─────────┼─────────────────────┼─────────────┼──────────╢
  ║ 1       │ "BOLETO BANCARIO"   │ "1"         │ 10469.15 ║
  ║ 2       │ "BOLETO BANCARIO"   │ "2"         │ 16279.45 ║
  ║ 3       │ "BOLETO BANCARIO"   │ "3"         │ 16279.45 ║
  ║ 4       │ "BOLETO BANCARIO"   │ "4"         │ 5810.3   ║
  ║ 5       │ "BOLETO BANCARIO"   │ "5"         │ 16279.45 ║
  ║ 6       │ "BOLETO BANCARIO"   │ "6"         │ 5810.3   ║
  ║ 7       │ "CARTÃO DE CRÉDITO" │ "1"         │ 10243.57 ║
  ║ 8       │ "CARTÃO DE CRÉDITO" │ "2"         │ 9178.03  ║
  ║ 9       │ "CARTÃO DE CRÉDITO" │ "3"         │ 10273.08 ║
  ║ 10      │ "CARTÃO DE CRÉDITO" │ "4"         │ 10110.4  ║
  ║ 11      │ "CARTÃO DE CRÉDITO" │ "5"         │ 10366.3  ║
  ║ 12      │ "CARTÃO DE CRÉDITO" │ "6"         │ 10768.75 ║
  ║ 13      │ "CARTÃO DE DÉBITO"  │ "1"         │ 15584.84 ║
  ║ 14      │ "CARTÃO DE DÉBITO"  │ "2"         │ 12400.53 ║
  ║ 15      │ "CARTÃO DE DÉBITO"  │ "3"         │ 13517.65 ║
  ╟─────────┼─────────────────────┼─────────────┼──────────╢
  ║ (15/41) │                     │             │          ║
  ╚═════════╧═════════════════════╧═════════════╧══════════╝
  </code></pre>
  
  <p>So, I believe the problem is with the result of Data.data. How can I purchase the complete date to show in chart?</p>