Forum Discussion
Bringing an array of data from a table into a custom function
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?
I now have a table coming in as a table, it was simply to make it:
(tablename as table)=> let source = "Something" in source
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?
2 Replies
Hi Anonymous ,
It seemed I could not achieve your pbix file:
Could you please check it again?
Regards,
Daniel He
I now have a table coming in as a table, it was simply to make it:
(tablename as table)=> let source = "Something" in source
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?
