Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
AutismRunner296
Frequent Visitor

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?PBI Slicer Query.png

1 ACCEPTED SOLUTION
rubayatyasmin
Super User
Super User

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.

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


View solution in original post

5 REPLIES 5
AutismRunner296
Frequent Visitor

Thank you both for your assistance

Happy to help

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


v-cgao-msft
Community Support
Community Support

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

AutismRunner296
Frequent Visitor

Thank you, I'll give it a go and report back

rubayatyasmin
Super User
Super User

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.

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.