Bringing an array of data from a table into a custom function

[Anonymous]

So I want to create some custom charts/graphs in power bi by using svg methods. To do this, I want to create a table that will have one row with a column for each chart which will be a basic html page with an svg in it that will be displayed using html viewer. The easiest way to show this will be to attach the pbix file here.

I have dummy data in the query, but I want to be able to pass in data from another table (in this case "Year Prices"). This table has 2 columns (Year and Price) that I want to basically send the entire data set into the function. The values going into the function at the moment are just dummy text fields, but how can I reference all this data from the function? Can I send in the required data as a json string or something somehow? Or can I send in a table name and the 2 column names and access them from within the query?

Initial Test File

[v-danhe-msft]

Hi @Anonymous ,

It seemed I could not achieve your pbix file:

Could you please check it again?

Regards,

Daniel He

[Anonymous · Accepted solution]

I now have a table coming in as a table, it was simply to make it:

(tablename as table)=>
let
    source = "Something"
in
    source

Updated example here.

Now, however, I can't work out how to loop through the table and process the data, started another thread, Could you please look here?