Using a scripting language to populate a report with a repeated chart...

[Anonymous]

I used to have a report in excel which was create by some VBA. It would generate a sheet full of burndown line graphs for each member of a team in rows of 5. If people joined or left the team it would adjust to add or remove that person. In PowerBi is there a scripting language that can achieve the same? Otherwise I have to manually lay out the report and remember to add and remove people when they join and leave the team/company. Thanks for any suggestions.

[v-lionel-msft]

Hi @Anonymous ,

Please give sample data and show the expected output effect, I will help you make a sample .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Let me try to reword. 

I want a PowerBi report that has a line graph for each item of a filtered list layed out in a grid. The number of graphs will change if I select different filter. How can I do that please?