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
takeiteasy
Frequent Visitor

Filter by month number for all tables

Hello to power bi community. I am newbie and I want your advice about something.

I have tables that works only with number of month. I want to create a month table so to be able to filter by month.

Let me give you an example:

I have 3 tables: CustomerTransactions, SupplierTransaction, PersonalTransactions

They look like :

MonthCustomerIDItemIDSalesManIDValue
112011120
212012100
112121130

 

SupplierTransactions:

MonthSupplierIDItemIDSalesManIDValue
11011120
11112100
21121130

 

PersonalTransactions:

MonthEmployeeIDItemIDValue
1101120
1111100
2112130


What I want is to create a month table that 1: they will give me back the name of the month 2: They will filter other tables based on selected month on the slicer.

I have create a table with the months numbers and name but when I am trying to connect two tables with the month table, it is says that this relationship will be inactive since it will create a conflict between an another table and Month.

Month table looks like:

MonthIDMonthName
1January
2February


How can I overcome this?  

2 ACCEPTED SOLUTIONS
SolomonovAnton
Solution Supplier
Solution Supplier

hello

create a relationship like in the picture below

SolomonovAnton_0-1657707237487.png

SolomonovAnton_1-1657707321804.png

 

 

If my message helped solve your issue, please mark it as Resolved! If it was helpful, consider giving it a Kudos!

View solution in original post

v-yanjiang-msft
Community Support
Community Support

Hi @takeiteasy ,

According to the error message, I think it's caused by ambiguity relationship, it means for example SupplierTransactions have two path to reach PersonalTransactions, you have to choose only. Additonally, you can't create closed loop relationship, it means for three tables, you can't make three active relationships between each other like below.

vkalyjmsft_0-1658139776014.png

Check whether the relationship of the three tables conforms to the situation I described above, then if you can't solve it by modify the relationship, please indicate their relationship here.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3
v-yanjiang-msft
Community Support
Community Support

Hi @takeiteasy ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

v-yanjiang-msft
Community Support
Community Support

Hi @takeiteasy ,

According to the error message, I think it's caused by ambiguity relationship, it means for example SupplierTransactions have two path to reach PersonalTransactions, you have to choose only. Additonally, you can't create closed loop relationship, it means for three tables, you can't make three active relationships between each other like below.

vkalyjmsft_0-1658139776014.png

Check whether the relationship of the three tables conforms to the situation I described above, then if you can't solve it by modify the relationship, please indicate their relationship here.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

 

SolomonovAnton
Solution Supplier
Solution Supplier

hello

create a relationship like in the picture below

SolomonovAnton_0-1657707237487.png

SolomonovAnton_1-1657707321804.png

 

 

If my message helped solve your issue, please mark it as Resolved! If it was helpful, consider giving it a Kudos!

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.