Displaying multiple Yes/No field in a % complete visual

Question

Hi All,&nbsp;This is my first post so go easy on me!I am creating a report dashboard that is capturing the progress of a document approval process (the data is being captured in a Yes/No column on a sharepoint list). At the completion of each step the column in the sharepoint list is changed to Yes.&nbsp;How do i convert the Yes/No data to allow me to display these results as a percentage complete in a visual?&nbsp;&nbsp;Any assistance would be grately appreciated.&nbsp;Thanks

amitchandak · Answer

Anonymous , can you share the expected output?
&nbsp;
Can you share sample data and sample output in table format?

anonymous · Answer

amitchandak&nbsp;&nbsp;Document Request #1st Draft Complete2nd Draft CompleteFinal Draft ApprovedUploadedTask Completed1YesYesYesYesYes2YesYesYesYesNo3YesYesYesNoNo4YesYesNoNoNo5YesNoNoNoNo6NoNoNoNoNo&nbsp;For Example in the report when 'Document Request #1' is selected a visual such as a 'gauge' will be displayed showing the percentage complete (e.g 100% complete).&nbsp;I would like to be able to give the requestor a visual on the status of their request.&nbsp;Hope that make sense&nbsp;Thanks

anonymous · Answer

Hi&nbsp;Anonymous,
I'd like to suggest you do unpivot column on your fields to attribute and values, then you can simply create a DAX formula based on the current attribute to calculate them to get the percent of values.
Unpivot columns (Power Query) (microsoft.com)Regards,Xiaoxin Sheng

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;I'm not not sure if i am missing something but when i unpivot the columns all the data is replaced by 'Error'?I am not an expert in power BI or DAX formulas, maybe i am trying to bit off something above my knowledge?&nbsp;ThanksSteve

anonymous · Answer

Hi&nbsp;Anonymous,
What error message that your query table shows? (you can click on these 'error' to see detailed information) BTW, I tested with your dummy data and unpivot column works well, you can check them if helps:
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUYpMLcZJxupEKxnhUeOXD1ZijEsSrsIEhxxcgSl2Kbi8GVYZiHQsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Document Request #" = _t, #"1st Draft Complete" = _t, #"2nd Draft Complete" = _t, #"Final Draft Approved" = _t, Uploaded = _t, #"Task Completed" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Document Request #", Int64.Type}, {"1st Draft Complete", type text}, {"2nd Draft Complete", type text}, {"Final Draft Approved", type text}, {"Uploaded", type text}, {"Task Completed", type text}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Document Request #"}, "Attribute", "Value")
in
    #"Unpivoted Columns"
Regards,
Xiaoxin Sheng

Forum Discussion

Displaying multiple Yes/No field in a % complete visual

7 Replies

Related content

Map displays multiple KPIs

display multiple elements with SELECTEDVALUE

Display multiple values with selectedvalue

Refresh completed with warnings

The subscription function cannot display all the table data completely.

Document Request #	1st Draft Complete	2nd Draft Complete	Final Draft Approved	Uploaded	Task Completed
1	Yes	Yes	Yes	Yes	Yes
2	Yes	Yes	Yes	Yes	No
3	Yes	Yes	Yes	No	No
4	Yes	Yes	No	No	No
5	Yes	No	No	No	No
6	No	No	No	No	No