Showing results for 
Search instead for 
Did you mean: 
New Member

Modeling and present info on charts



I have test measurement data from a product and I would like to present in a line chart with the average amount of failed products perd day. For example a pass product should have Measurement 1 > 0.01


In dayly log files( with arround 72000 units tested per day)  I have the  information in the following way (1-pass/ 0-fail)

Date                    Time                 Product id        Measurement 1     Pass/fail
26/03/2019      00:17:04         6EEC9                0.0108                            1

Since I have dayly files with the test information of  a whole month, I would like to present the dayly average or percentage  of failed units. I dont know how to arrange  or model my data to be able of present a line chart plot (x-axis-date in days 1-30 and y-axis average or % of failed units)


I understand tha in some way I should modify the data  measurement in tables so I can estimate the failed % per day.

1.But I wonder if someone can help me to suggest how to moddel my data??

2.Should I create an additonal table with the  pass % result of each day ??  I wonder if there is an easier way since I require to update the information with new data of everyday.



thank you in advance


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Kudoed Authors