Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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?

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support

    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.