Forum Discussion

AutismRunner296's avatar
AutismRunner296
Frequent Visitor
3 years ago
Solved

Linking a table value to a date slicer

Good day everyone, fairly new to PBI so I am quite green at the moment.   I have two two tables, the one table contains a number of fields including a date field (which I have used for a slicer), a...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    3 years ago

    Hi, AutismRunner296 

     

    here is the suggestion, you can follow. 

     

    1. Ensure a "Week" field exists in both tables with matching formats.
    2. Establish a relationship between the tables based on the "Week" field.
    3. Use a slicer based on the "Week" field to filter both tables simultaneously.
    4. Create a visual to display the sprint name and corresponding story points filtered by the selected week.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi AutismRunner296 ,

 

The slicer can filter other visual, but other visuals won't filter the slicer. Also is there a common field between the two tables to connect between?

 

In my demo, you can create 2 new measures to get the startweek and endweek. please check the pbix file.

Please feel free to contact me if I have misunderstood your needs or if the problem has not been resolved! A file without private data and a screenshot of the expected output would be nice.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum