Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerQuery meets thinkcell

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).

 

Need Help

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

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

     

    Pat

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks pat,

     

    Thats my goal. But how do I do it?

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    5 years ago

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