Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Change Dataset

Hello Everyone,   I am not so used to work with PBI, so i got a question.   I have an excel file of the monthly registry, which is where I update the registry every month. For 2021, I therefore h...
Need Help
  • AdamBoltryk's avatar
    AdamBoltryk
    4 years ago

    Hi, Merge all table in one and add column with year/filename.

    Than you create ONE report and use this column in a filter/slicer.

    Merge it in Query, and download to model just one column. Will be easier.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello,

 

Thanky for your answer, but not sure about the answer. I try to explain again my problem, which i think it is quite simple to manage.

 

I already have loaded in power bi some tables from other tables with the same name in an Excel Workbook.

 

Now, i have created the reporto for one of these table. What i would like to do, is just replicate the same reporto for all the others tables. Is that possible?

 

Thank you in advance,

Luca

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Anonymous ,

 

I see that these tables all have the same table structure, just different table names. 

 

If you want to create the same visualization for other tables in the same PBIX file, you can try duplicating pages or copying visuals to other pages and then replacing columns in the tables (but measures and calculated column will need to be recreated).

Or you can follow AdamBoltryk 's method to associate all tables together and switch table through the slicer.

 

If you want to create a separate PBIX file for each table, you can create report templates.

Create and use report templates in Power BI Desktop 

 

 

Best Regards,
Winniz