Forum Discussion

Jyaul1122's avatar
Jyaul1122
Icon for Helper III rankHelper III
1 year ago
Solved

Dates based on Slicer selection

Hi, I have two tables Fact and Date table, both are link many to one with Fact(data_date) and Date table(Dates). Fact Table: Project Data_Date Actual Date Project1 5/22/2025 11/19/2030 ...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi Jyaul1122,

    Thank you for reaching out to the Microsoft fabric community forum. Aslo thanks to lbendlin, for his inputs on this thread. I reproduced the scenario again, and it worked on my end. I used my sample data and successfully implemented it.

    Relationship:

     

    Outcome:

    I am also including .pbix file for your better understanding, please have a look into it:

    Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

    Thank you for using the Microsoft Community Forum.




v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Jyaul1122,

Thank you for reaching out to the Microsoft fabric community forum. Aslo thanks to lbendlin, for his inputs on this thread. I reproduced the scenario again, and it worked on my end. I used my sample data and successfully implemented it.

Relationship:

 

Outcome:

I am also including .pbix file for your better understanding, please have a look into it:

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.




  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Jyaul1122,

    Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

    Thank you!

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi Jyaul1122,

      Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

      Thank you.

      • v-kpoloju-msft's avatar
        v-kpoloju-msft
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi Jyaul1122,

        Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

        Thank you.