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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
juancmr1
New Member

New tables with Average per day

Hello,

I am new in Power bi and I have  1 text file per day with the information of 4000 units tested per day.

Each unit produced is tested and I would like to follow the average value and percentage of failed units

 

I have in mind 2 diferent Line Charts:

1) x-axis date by day ;  y-axis  average value  (average of testeValue)

2) x-axis date by day ;  y-axis  % failed units  (1-fail; 0-pass)

 

The daily files are in this form:

Date               Time             UnitNo     TestValue     Pass-Fail

05/04/2019     03:30:17       unit1         3.1                   1

 

 

I dont know what is the esiest way to create these charts.

Mybe edit my data in the query editor and create additional tables?

 

1- I have difficulty to  create 2 additional tables in the query editor one with the average value per day and other with the percentage failed per day????

What is the best way to create and populate this tables using the data from the daily files?

 

I would appreciate if you can give me a pice of advice of how is the simplest way to to this

 

thanks in advance

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @juancmr1 ,

I'd like to suggest you create a measure to calculate failed percent, then you can create line and clustered column chart to show these value at same time with different y axis. (date to axis, average amount to column value, measure to line value)

Regards,

Xiaoxin Sheng

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

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @juancmr1 ,

I'd like to suggest you create a measure to calculate failed percent, then you can create line and clustered column chart to show these value at same time with different y axis. (date to axis, average amount to column value, measure to line value)

Regards,

Xiaoxin Sheng

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

Thank you very good suggestion and it worked perfect

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.