Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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
Thank you very good suggestion and it worked perfect
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |