Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
Hi, @AutismRunner296
here is the suggestion, you can follow.
Proud to be a Super User!
Thank you both for your assistance
Happy to help
Proud to be a Super User!
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
Thank you, I'll give it a go and report back
Hi, @AutismRunner296
here is the suggestion, you can follow.
Proud to be a Super User!
User | Count |
---|---|
128 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |