New Member
October 1, 2020
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
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"
Answers Post
1 Guest(s)