Forum Discussion
Display value by step
Hi,
I've got a table with thiese kind of values
| Service | Date | Problem | Start Date | End Date | Status |
| Windows | 14/02 | Blue screen | 14/02 | 14/02 | Completed |
| Excel | 14/02 | macro stuck on launch | 14/02 | 14/02 | Completed |
| Word | 14/02 | mail merge error | 14/02 | In progress | |
| Outlook | 14/02 | no email synchronization | 14/02 | In progress |
I'd like to display informations in my report like this :
Service : Windows
Problem : Blue screen
Start Date : 14/02
End Date : 14/02
Status : Completed
Service : Excel
Problem : macro stuck on launch
Start Date : 14/02
End Date : 14/02
Status : Completed
.....
This report is daily, based on Date, and each days, i could have more or less service to display.
How can i create this type of report ?
Thanks for your help.
Hi guenfood ，
Based on your description, I think you can convert that table in power query first and then merge the two columns. I did the test with the following reference:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hY29CsMwDIRfRXgO9Ic+QUuHTh0zhAzGFqmJLQXJpj9PXxMouEs7iAPd3XfDYPpAnu9qOrM7bLb7qsdYENQJIjXfj544LREzejN2gzk/HMbGTdYJg+biZmCCaAu5219Kz+K/ICFCQpkQUISlsaDehWARngRV1/a15Mg8NyliwBWizzovTOFlc2D6BRrf", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Service = _t, Date = _t, Problem = _t, #"Start Date" = _t, #"End Date" = _t, Status = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Service", type text}, {"Date", type text}, {"Problem", type text}, {"Start Date", type text}, {"End Date", type text}, {"Status", type text}}), #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value"), #"Added Custom" = Table.AddColumn(#"Unpivoted Columns", "list_", each [Attribute] & ":" & [Value]), #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Attribute", "Value"}) in #"Removed Columns"
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
guenfood , add unique ID for each row using Index column in Power Query
Then you can add Index on Row and all other values and you can take min max. Then enable show on row
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Thanks for your answer.
I create the index column but i don't succeed to achieve the display I want.
Hi guenfood ，
Based on your description, I think you can convert that table in power query first and then merge the two columns. I did the test with the following reference:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hY29CsMwDIRfRXgO9Ic+QUuHTh0zhAzGFqmJLQXJpj9PXxMouEs7iAPd3XfDYPpAnu9qOrM7bLb7qsdYENQJIjXfj544LREzejN2gzk/HMbGTdYJg+biZmCCaAu5219Kz+K/ICFCQpkQUISlsaDehWARngRV1/a15Mg8NyliwBWizzovTOFlc2D6BRrf", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Service = _t, Date = _t, Problem = _t, #"Start Date" = _t, #"End Date" = _t, Status = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Service", type text}, {"Date", type text}, {"Problem", type text}, {"Start Date", type text}, {"End Date", type text}, {"Status", type text}}), #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value"), #"Added Custom" = Table.AddColumn(#"Unpivoted Columns", "list_", each [Attribute] & ":" & [Value]), #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Attribute", "Value"}) in #"Removed Columns"
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
