Clustered column chart duplicating axis values

[Tinashe]

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 (0 and 1) for the axis

 

[v-danhe-msft]

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]

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]

Hi @Tinashe,

Could you please post  a picture about your data stracture?

Regards,

Daniel He

[Tinashe]

Hi

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

Tabular ModelPensioner Ind Calculated Table