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.
Hello,
I am attempting to create a Gantt chart to show the flow of projects happening over the course of two years. My excel document I am pulling from currently has the following columns:
1) Project Name
2) Region
3) Stage Start (for project)
4) Stage End (for project)
5) Employees
6) Employee's time % allocated to project
7-XXX) And from here I have listed every week from 1/1/2017 to 12/31/2018
The problem not creating a Gantt chart. I have created that with no problems. But I want to be able to use a slicer to select a date range and then ANY project that is active during that range shows up on the Gantt chart. It is not very helpful to have a 'Stage Start' and 'Stage End' slicer. I would much rather have one slicer, 'Date Range', and proceed from there.
Hi @matthewfe,
Please create a calendar table. Drag [date] from this calendar table to date range slicer.
dim = CALENDAR(DATE(2017,1,1),DATE(2018,12,31))
Then, create a measure with below DAX. Add this Flag measure into visual level filter of Gantt chart and set its value to 1.
Flag = IF ( SELECTEDVALUE ( Project_tab[Stage Start] ) >= MIN ( dim[Date] ) && SELECTEDVALUE ( Project_tab[Stage End] ) <= MAX ( dim[Date] ), 1, 0 )
Best regards,
Yuliana Gu
This did not solve my issue. There is a chance I did not properly explain what I needed.
What you did make sense but I will explain the result. There is a certain project, project X, I used to test the slicer.
The start date is 6/11/2018 and the end date is 6/24/2018. I set the slicer end date to 6/1/2018 and the start date remained at 1/1/2017. The desired result would be that project X is taken out of the gantt chart. This was not the case. It made no affect on the chart whatsoever.
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |