Forum Discussion

Tinashe's avatar
Tinashe
New Member
7 years ago

Clustered column chart duplicating axis values

Hi  Please help with an issue I am having. I am trying to create a clustered column chart from a Tabular model SSAS data source. It is duplicating the value 1 for graphs that have only two values (...
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Tinashe,

Due to I could not reproduce your problem, could you please share your sample file if possible? And could you please check the value in your [PensionerInd] column, it seems that the format of the first [1] is different form the second [1] in the X Axis.

 

Regards,

Daniel He

  • Tinashe's avatar
    Tinashe
    New Member
    7 years ago

    Thanks for the suggestion, unfortunately I can't provide a sample. The data type was the same, originally int from the database tables then whole number in the model. I had to change it to True/False and it is now displaying the two values.

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      Hi Tinashe,

      Could you please post  a picture about your data stracture?

       

      Regards,

      Daniel He

      • Tinashe's avatar
        Tinashe
        New Member
        7 years ago

        Hi

         

        This is a snippet of the Model. Pensioner Ind table is a calculated table

        Tabular ModelPensioner Ind Calculated Table