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.
Hi PowerBI afficionados,
I have a list of projects with a Start date and End date.
What I am trying to achieve is to visualize the number of open projects (so projects which have started, but are not closed in a previous time frame). The time slicer should only filter the selected time frames, but currently it filters the start dates and end dates as well.
I have a separate Time Table which has no active relation to my Projects Table.
Visualizations below.
Help would be greatly appreciated.
Solved! Go to Solution.
You may take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
You may take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
Thanks, this worked.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
125 | |
78 | |
76 | |
59 | |
51 |
User | Count |
---|---|
166 | |
84 | |
68 | |
67 | |
57 |