Forum Discussion
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), and a second table which contains the name of Agile Sprints and the perceived effort neded for each Sprint, which is measured in Story points.
The slicer is setup so that you can choose week, month, quarter and year. Is there a way of linking the two tables so that it knows which two weeks the Sprint is linked to and show the corresponding Story points for it?
For example, in the screenshot attached you can see that each Sprint is worth 39 points, if I were to select that Sprint can I show which weeks that corresponds to on the slicer, or vice versa if I chose the slicer first?
Hi, AutismRunner296
here is the suggestion, you can follow.
- Ensure a "Week" field exists in both tables with matching formats.
- Establish a relationship between the tables based on the "Week" field.
- Use a slicer based on the "Week" field to filter both tables simultaneously.
- Create a visual to display the sprint name and corresponding story points filtered by the selected week.
5 Replies
rubayatyasminCommunity Champion
Hi, AutismRunner296
here is the suggestion, you can follow.
- Ensure a "Week" field exists in both tables with matching formats.
- Establish a relationship between the tables based on the "Week" field.
- Use a slicer based on the "Week" field to filter both tables simultaneously.
- Create a visual to display the sprint name and corresponding story points filtered by the selected week.
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 TeamIf 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
Thank you, I'll give it a go and report back
Thank you both for your assistance
- rubayatyasmin
Happy to help
