Forum Discussion
Roster Planning
Hello Folks,
I'd like to create an interactive planning where people are assigned to specific tasks with random duration.
My data are stored in an Excel Spreadsheet (people, tasks, start date, end date).
My problem is that once inserting such data in the Dashboard matrix visual, the tasks are only looking at start date and don't cover the full duration as specified (from start to end date).
Could anyone help me with this ?
Cheers
Hi SoLoNOx , do you want something like this?
To achieve this, you need to transform the data in Power Query Editor first. Try below codes in Advanced Editor and you will get a new column Dates. Then put this Dates column in a matrix visual. Here is a PBIX file for reference.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WilDSUTIyMDLUNdQ1QTAtgExnH1dHP08/d6VYnWilSIScJYJpaABkhzsGe8CURSHJWSDYRqZAdoCjp18IWGEsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [People = _t, #"Start Date" = _t, #"End Date" = _t, Job = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"People", type text}, {"Start Date", type date}, {"End Date", type date}, {"Job", type text}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Dates", each List.Dates([Start Date], Duration.Days([End Date]-[Start Date])+1, #duration(1, 0, 0, 0))), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Dates"), #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Custom",{{"Dates", type date}}) in #"Changed Type1"Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
4 Replies
SoLoNOx , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
refer if one of this can help
Hi amitchandak ,
Here is a sample of random data (Excel and its implementation on pbix)
You can see that activities are directly linked to the "first" date which is the Starting Date whereas I'd like to have the task (Cleaning) from the 4th to the 8th and not only showing for the 4th..
Thanks for your quick reaction though !!
Hi SoLoNOx , do you want something like this?
To achieve this, you need to transform the data in Power Query Editor first. Try below codes in Advanced Editor and you will get a new column Dates. Then put this Dates column in a matrix visual. Here is a PBIX file for reference.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WilDSUTIyMDLUNdQ1QTAtgExnH1dHP08/d6VYnWilSIScJYJpaABkhzsGe8CURSHJWSDYRqZAdoCjp18IWGEsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [People = _t, #"Start Date" = _t, #"End Date" = _t, Job = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"People", type text}, {"Start Date", type date}, {"End Date", type date}, {"Job", type text}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Dates", each List.Dates([Start Date], Duration.Days([End Date]-[Start Date])+1, #duration(1, 0, 0, 0))), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Dates"), #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Custom",{{"Dates", type date}}) in #"Changed Type1"Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
