Power BI solution for replacing separate SharePoint Folders

Thanks for the reply fromMFelix,, please allow me to provide another insight:

Hi,Graemess 

Have your problems been solved? If you find a solution, feel free to share it with us, which will help other community members with the same problem find a solution faster.

Regarding the issue you raised, my solution is as follows:

Depending on your needs, you can try using the date column as a slicer and using the directquery storage mode to store the data.

1.First you can create a date table using the following calculation table:

main Table = CALENDAR(DATE(2024,3,19),TODAY())

Select the date hierarchy you want as the slicer.

Here is the relevant documentation:

Select the date hierarchy you want as the slicer.

Here is the relevant documentation:

Auto date/time in Power BI Desktop - Power BI | Microsoft Learn

Slicers in Power BI - Power BI | Microsoft Learn

2.Next, establish relationships with the tables you need to control:

Here is the relevant documentation:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

This makes it possible to use only the data selected by the slicer.

3.Here are the final results:

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.