cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mrben100 Frequent Visitor
Frequent Visitor

power bi report help please

Hi


I am trying to make equipments availability report for certain date from 2 tables linked together by specific date say for example (03/03/2019)

that date return to the jobs that we did in some equipments. When i run the report i got only the equipments that have jobs

on that day but i neeb my report to show all the equipments even those has no job on that day because those equipments without

job are working and i want to show that they have 100% availability .

report1.pngthis what i got from the report

 

report2.pngand this what i need to show all of my equipments

( in Access it is easy by editing the relathionship properties and chose keep all records from first table)


Thanks

waiting for help please

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: power bi report help please

Hi @mrben100 ,

 

You can consider extract date value to create a bridge table to link two tables, then you can choose single direction relationship to let it keep all records.

HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI

 

Regards,

Xioaxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Community Support Team
Community Support Team

Re: power bi report help please

Hi @mrben100 ,

Have you consider to break relationships and write a measure to achieve filter effect?

Applying a measure filter in Power BI

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
4 REPLIES 4
mrben100 Frequent Visitor
Frequent Visitor

Re: power bi report help please

waiting for help please
Community Support Team
Community Support Team

Re: power bi report help please

Hi @mrben100 ,

 

You can consider extract date value to create a bridge table to link two tables, then you can choose single direction relationship to let it keep all records.

HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI

 

Regards,

Xioaxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
mrben100 Frequent Visitor
Frequent Visitor

Re: power bi report help please

thanks for your response

but the dates are in only one table the (job_code) is the relation between the tables if i want to extract a column to be a bridge

is the job_code.

Community Support Team
Community Support Team

Re: power bi report help please

Hi @mrben100 ,

Have you consider to break relationships and write a measure to achieve filter effect?

Applying a measure filter in Power BI

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |