Forum Discussion

Justiy's avatar
Justiy
Regular Visitor
3 years ago
Solved

same report - how to the change source file ?

Hello, I have couple of excel files which I use as a datasoruces for my pbi report, which I built for a specific excel file. I want to add some kind of a filter, in which I can choose which datasou...
Need Help
  • tackytechtom's avatar
    tackytechtom
    3 years ago

    Hi Justiy ,

     

    I would have suggested exactly that: Merge or rather union the files into one with an additional column describing the Month. After you can use that month column as a slicer. You could do something similar in DAX as well, but Power Query is to prefer in that scenario. Out of curiosity, why do you not want to union them into one file? 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

Justiy's avatar
Justiy
Regular Visitor
3 years ago

Hello tackytechtom  and thanks for your replay,

 

My excel files containes a lot of data and analysis, and not all the tables are equales.

So I think that megring will be hard to do.

 

Is there any other ways?

  • tackytechtom's avatar
    tackytechtom
    Icon for Most Valuable Professional rankMost Valuable Professional
    3 years ago

    Hi Justiy ,

     

    If you are showing the exact same graphs in your report, I would still create a union table with a month column. 

     

    If you are using different columns and charts per month, I'd suggest to look into bookmarks and buttons so you can hop from one page to another with the help of buttons.

     

    Hope this helps! 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/