Forum Discussion

MortenK's avatar
MortenK
Regular Visitor
4 years ago
Solved

Converting List to Group

Hi,   I have made a query towards Airtable, and my data came sorted in Lists. I have not been able to convert this data to Groups such that I am able to organise charts on the basis of the data beh...
Need Help
  • MortenK's avatar
    MortenK
    4 years ago

    Thanks Pete,

     

    I ended doing a walk around and using Table.AddColumns, which leaves me with the first datapoint and access to using the data in the graphics. The first element is the most cruical either way so this was fine. Thank you for the support. 

     

    = Table.AddColumn(#"Renamed Columns1", "Industrials.1", each if Value.Is([#"Industrials Rollup (from Industrials)"],type list) then [#"Industrials Rollup (from Industrials)"]{0}

    else "")

     

    Morten

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi MortenK ,

 

In the example provided, you could just expand the list column using the two outward arrows button at the top-right of the column. However, this would duplicate your row, one row for Fashion and another for Manufacturing. 

How would you want the row values apportioned between the different industries?

Would you want the investment value to be split evenly over each industry, or would you want the row to remain distinct, but have the industry group be displayed as "Fashion, Manufacturing"?

 

Pete

MortenK's avatar
MortenK
Regular Visitor
4 years ago

Thanks Pete,

 

I ended doing a walk around and using Table.AddColumns, which leaves me with the first datapoint and access to using the data in the graphics. The first element is the most cruical either way so this was fine. Thank you for the support. 

 

= Table.AddColumn(#"Renamed Columns1", "Industrials.1", each if Value.Is([#"Industrials Rollup (from Industrials)"],type list) then [#"Industrials Rollup (from Industrials)"]{0}

else "")

 

Morten