Data Modelling to remove repeating values in X Axis

[Yoshimitsu411]

Hi All

I'm having a bit of trouble trying to get my clustered column chart to not show repeating X axis values.

Below is my data model where JEN ZNX Projects Dimension Table is a Left Outer Merge of the JEN Projects Report Fact Table and the ZNX Project Report Fact Table.

When I create my clustered column chart using column Asset (from the dimension table) I get the following repeating values in the X axis. 

Ideally what I want is this. Also, the clustered chart should be filterable when a value from the dimension table is selected.

How do I do this? Thank you for any suggestions.

Yoshi

[amitchandak · Accepted solution]

Why the so-called dimension table is having Many to 1 and Many to many relations. Ideally, Relation with the project dimension should 1-many.

Use summarize or distinct to create a table that has unique project information.

Or even you can create you measure there you can use summarize to get the values

[Yoshimitsu411]

Thanks I will try it and get back to you.