Hello,
I have to prepare a bar chart in Power BI desktop showing the on time percentage total projects delivered in a period.
In excel I know how to do it but in Power BI desktop, I dont find the proper tools.
I am new in this field and any assistance would very helpful.
Thank you in advance,
Bogdan
Hi Bogdan,
Welcome to our forum!
How are you calculating the 'on time delivery percentage'? Please provide an example formula that you'd use in Excel.
Mynda
Hi Mynda,
I have attached the test file updated with my formulas.
Tried to do the same in power BI desktop - query but not found the functions. If you can assist would be great.
Thank you.
Best regards,
Bogdan
Salut,
If you have tried to find in Power BI the same functions from excel, you should know that they are not the same, you have to build the calculations using M functions.
Try:
let
Source = Table1,
#"Filtered Rows" = Table.SelectRows(Source, each [#"Pre - calc"] <=0),
Result= Table.FromColumns({{Table.RowCount(Source)},{Table.RowCount(#"Filtered Rows")},{Table.RowCount(#"Filtered Rows")/Table.RowCount(Source)}}, {"Projects on Time","Total number of Projects","Delivery on Time"}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(Result, {}, "Attribute", "Value")
in
#"Unpivoted Columns"
