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

AdamBoltryk's avatar
AdamBoltryk
Resolver I
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.