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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks I will try it and get back to you.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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