Display value by step

[guenfood]

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.

[v-henryk-mstf · Accepted solution]

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.

[guenfood]

Thanks for your answer.

I create the index column but i don't succeed to achieve the display I want.

[amitchandak]

@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