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
rautaniket0077
Resolver I
Resolver I

Filtering between tables not happening

Hi Everyone,

I have 2 tables (batch and job) I need job table to show jobdetails when any user select batch_id from batch table. Both tables are connected via batch_id in one to many relationship with batch table filtering job table

 

current scenario -- I am able to filter the job table when perticular batch_id is selected in batch table but as i am adding batch_start_time (date time column) in batch table and selecting batch_id from batch table the job table turns to blank showing no values at all.

 

Does anybody know, why it's happening ??

 

other details 

batch table --

columns

1) batch_id

2) batch_start_time

3) batch_end_time

4) batch_status

5) created_date

 

job table --

columns

1) batch_id

2) job_id

3) job_start_time

4) job_end_time

5) job_status

6) created_date

 

note --  can't provide any data.

 

1 REPLY 1
Sahir_Maharaj
Super User
Super User

Hello @rautaniket0077,

 

Here are a few things you can check to troubleshoot:

 

  1. Ensure that the relationship between the batch table and the job table is correctly defined and established. The batch_id column in the batch table should be related to the batch_id column in the job table.

  2. Confirm that the filtering condition on the relationship is set correctly. The relationship should be set to filter the job table based on the selected batch_id from the batch table.

  3. Verify that there are matching records in the job table for the selected batch_id. If there are no matching records, the job table will appear blank when a batch_id is selected.

  4. Check the format of the batch_start_time column in the batch table. Ensure that it matches the format expected in the relationship and filter conditions. Date/time formats should match exactly for the filtering to work properly.

  5. If you have made any changes to the batch table or the job table, make sure to refresh the data in Power BI to reflect the updated relationship and filter conditions.

Should you need further assistance please don't hesitate to reach out to me.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 13K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

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.

Top Solution Authors