Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Adding file name & path as a column attribute

Hi everyone, I'm hoping someone can assist. I'm using a SharePoint folder as a data source for a report. The folder contains XLSX files that will be added to each month, e.g.:

 

Commercials_2019.06.xlsx

Commercials_2019.07.xlsx
Commercials_2019.08.xlsx
Commercials_2019.09.xlsx

 

The table of data in each XLSX is similar to the below. I'd like to be able to add a File Path column to the tables:

 

DocIdAuthorAuthor DepartmentFile Path
400029Jimmy JamesSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029Jimmy JamesSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029Kelly kellysonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.07.xlsx
400029Kelly kellysonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400029Peter PetersonServices<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400030Peter PetersonServices<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.08.xlsx
400030Petra PetrasonC-Suite<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030Sarah SarahsonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030Sarah SarahsonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030Jimmy JamesSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.09.xlsx
400030Kelly kellysonFinance<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030Kenny KennysonSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030Kenny KennysonSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030Mark MarksonSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400030Mark MarksonSales<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx
400035Michael HutchensServices<Sharepointsite.com>\DocLibrary\CommercialReports\Commercials_2019.06.xlsx

 

This would enable me to add File Path to a slicer, to slice data based on month.

Any assistance would be appreciated.

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi, @Anonymous 

You could expand the context of all the xlsx, then extract month value by Split Column in edit queries.

Then use it as a slicer.

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks @v-lili6-msft  - not sure what we mean by the following?


@v-lili6-msft wrote:

You could expand the context of all the xlsx


 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.