PowerQuery meets thinkcell

[Anonymous]

Hi,

I want to have a bar chart of invest and impact for every project in thinkcell.

Is there a way to transform the data like in the picture below? Then I Would be able to link each bar chart. (think cell demands a certain data structure).

 

[wdx223_Daniel · Accepted solution]

NewStep=Table.FromRows({List.Combine(Table.ToRows(PreviousStep))})

[Anonymous]

Thanks pat,

Thats my goal. But how do I do it?

[mahoneypat]

I am not familiar with ThinkCell but you should be able to do all you need with Power BI.

Pat