Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have variouse sets of data that I am displaying using the Gantt Chart by MAQ. each set has variouse max end dates and therefore the date ranges change for the bar chart. I would like to show the same date range for all charts regardless of the max date in the data being displayed. Is this possible at all?
Hi @Anonymous ,
Hi Icey,
thanks for the reply. I think i have misled you in the wording of my problem. I have one data set. I need to display the Gantt chart on different pages (one for each department). Where the max or min dates for each department vary, the date range shown on the chart varies. I want to make them all the same. hope that is clearer!
Hi @Anonymous ,
If so, you can try the method @Anonymous provides.
Best Regards,
Icey
Hi @Anonymous ,
Maybe you can try these measures:
MaxEndDate = MAX ( CALCULATE ( MAX ( 'Table 1'[EndDate] ) ), CALCULATE ( MAX ( 'Table 2'[EndDate] ) ) )
MinStartDate = MIN ( CALCULATE ( MIN ( 'Table 1'[StartDate] ) ), CALCULATE ( MIN ( 'Table 2'[StartDate] ) ) )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Try creating a date table and then link it to your data tables in the model.
use the dates from the date table in the visuals
Cheers!
A
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |