Automatic report for selected variables

[Scoppio]

Hello,

I'm working on reports with Power BI regarding questionnaires for different companies. Each company has 2 questionnaires of 90 questions each.

Is there a way to select all the variables I want to report and have them automatically shown individually through a chosen chart on different pages?

I am doing the same process for each variable by hand and it's incredibly time-consuming.

The picture is to show that I have to repeat the same chart duplicating it, changing its variables and renaming it, for each question.

Thanks guys, hope you can help me

[MFelix · Accepted solution]

Hi @Scoppio ,

You cannot make this variable change trough the different pages, you need to create each page individually.

What you can do is to automate the part of the title and of the selection using a dinamic measure and use of slicers instead of the filter pane. Making it that way you can even have a single page and users could select the options.