Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Hopefully simple one... I have 2 Tables -
A Project Table which holds 2x columns - A Start Date and an End Date
A generic Date Table
Currently the model has a relationship between End Date and the Date Table.
I have a Date table filter on the page of November 2019.
1 Row from the Project Table has a start date of 1 September 2019 and end date of 31 December 2019.
Therefore because of the relationship with End date, it does not show. I need it to show because the month of November falls between the Start and End date.
Help please.
Cameron
Solved! Go to Solution.
remove relationship between two tables.
USe your generic table in slicers whatever it is after slicer before slicer or between slicer.
Create one measure.
Filter= IF(Min(project[StartDate])<=min(Calendar[Date]) && Min(project[CloseDate])>=min(Calendar[Date]),1,-1 )
Add this measure in visual level filter and set it to 1.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
remove relationship between two tables.
USe your generic table in slicers whatever it is after slicer before slicer or between slicer.
Create one measure.
Filter= IF(Min(project[StartDate])<=min(Calendar[Date]) && Min(project[CloseDate])>=min(Calendar[Date]),1,-1 )
Add this measure in visual level filter and set it to 1.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |