Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Yoshimitsu411
Resolver I
Resolver I

Data Modelling to remove repeating values in X Axis

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.

 

Capture.PNG

 

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

 

DoubleBar.PNG

 

 

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

 

 

DoubleBarCorrect.PNG

 

 

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

 

Yoshi

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

Thanks I will try it and get back to you.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.