CODEWITHSUNDEEP
powerbidaxpowerbi-desktopslicers
Arif Sher Khan
Arif Sher Khan

Reputation: 585

Power BI - Use slicer to fetch file from folder

I have files in a folder which have same structure. The only difference between them is that for each day a new file is created which is named as date of the day.

So if file is created on 11th November 2019, its name would be 11092019.xlsx.

I have created a slicer which fetches names of all files present in this folder.

Keeping in mind that file format is same and only difference is in their file name and data values in them. Is there any way so that when I select a value from slicer the respective files data will be displayed in table visual ?

Upvotes: 0

Views: 455

Answers (1)

Kosuke Sakai
Kosuke Sakai

Reputation: 2411

It is not possible to load a file interactively based on the slicer value.

You can achieve this by,

  • Load all files in the folder.
  • Combine them into a single table, where you need to add a "File Name" column.
  • Use slicer to show records coming from the specific file.

Upvotes: 1

Related Questions