Power BI custom text view and grouping

[Nuage]

Hello, I have a Power BI problem however I have no reasonable knowledge of the tool and was kind of forced to use it as my csv data file was too large for Excel so I'm hoping for some guidance from the community.

I have the data and a simple view already and now require an alternate view.

The CSV file has the following columns:
Timestamp | Path | Size

In my existing view I have been able to use the automatically created heirarchy for the date so as to group by year, and also added a column to convert size from bytes to GB as shown in the first screen shot.

For the new view I would like to have a drill down section which focuses and group the files based on the directory level as shown in the image from L1 down to L3 while ignoring the prefix G:\GDrive\ bounded in the Red box. The resulting view would then show 2 columns
Directory | Size (GB)
and these columns should then replicate as the user drills down.

I'm sure it's not exactly difficult as I know exactly how I'd do this in Excel with a pivot table. I'm just clueless on how to convert this to a PowerBI query.

Thank you.

[Nuage · Accepted solution]

Thanks for the tips. You've given me some things to learn about. Turns out I discovered an easier way (for me, at least) by using a transform and a split, then showing only the split columns that I needed.

Your input was appreciated all the same.

[Anonymous]

If you already know how you do it in excel with a pivot table then you can Use power query to query the CSV and load it to the day tomorrow and then make a pivot table from the Data Model.  I doubt that you'll hit the size limit in PowerPivot.

--Nate

[wdx223_Daniel]

NewStep=Table.SplitColumn(PreviousStepName,"Column3",each List.FirstN(List.Skip(Text.Split(_,"\"),2),3),{"L1","L2","L3"})

[Nuage]

Thank you I'll give this a shot. In reference to the last array, is it safe to presume I can replace the L1,L2 etc with wildcards?