Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issues creating visuals due to the sharepoint data

Hi everyone, I am working on creating a dashboard for my company, this dashboard is meant to analyze department capacity.  (this data is coming from a Sharepoint Intake form) So when a department ha...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Not sure if I understand correctly. If you want to show sub-departments in a cell with line breaks, you can try the following code.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUfLNTEnJSVXwTSzKTi3RCc5NzMlRcM7PzU0tSs5MzNHxSE3MKclITixKVdBVcMzJUYrViVZyAupzzgcKOfsARdH1gJU4A5X4l2SkFoF5LkAewiQdn8zEpMyczJJKsKQrYVe4xpQaGBiZBWNxTiwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Department = _t, #"Business Unit" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Department", type text}, {"Business Unit", type text}}),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Changed Type", {{"Business Unit", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Business Unit"),
    #"Grouped Rows" = Table.Group(#"Split Column by Delimiter", {"Department"}, {{"Business Unit", each Text.Combine([Business Unit],"#(lf)"), type nullable text}})
in
    #"Grouped Rows"

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.