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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Responsive Resident
Responsive Resident

hello

create a relationship like in the picture below

SolomonovAnton_0-1657707237487.png

SolomonovAnton_1-1657707321804.png

 

 

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
Responsive Resident
Responsive Resident

hello

create a relationship like in the picture below

SolomonovAnton_0-1657707237487.png

SolomonovAnton_1-1657707321804.png

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.