Forum Discussion

C-Ristau's avatar
C-Ristau
New Member
2 years ago

Filtering Data between two entries in a SharePoint list

I need to be able to filter a data table based on the entries of a sharepoint list. I have a data model that houses produciton data. I also have a sharepoint list that houses project information. The sharepoint list has a project start date and a project end date. I set a summary page to show all the projects for the year then I set up a drill through so you can look at a specific project. I need the data in the drill through to be automatically filtrered between that specific projects start and end date. 

Need Help

3 Replies

  • NaveenGandhi's avatar
    NaveenGandhi
    Memorable Member
    2 years ago

    Hi C-Ristau 

    Can you share sample data along with screenshots to understand the problem better.

    Regards,
    NG

    • C-Ristau's avatar
      C-Ristau
      New Member
      2 years ago

      I esentially need something that functions like this:

       

      where the parameters for a slicer are populated using the entries from a sharpoint list

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, C-Ristau 

    May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.


    If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

     

     


    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.