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 Everyone,
I'm having an issue producing a graph that has a dynamic band as the Column series.
The DAX I'm using is as follows:
TaskPerfSum = VAR TaskSum = SUMMARIZECOLUMNS ( Task[TaskID], Task[StartDateYearMonth], Task[StartDateYearMonthSortBy], "TotalDuration", SUM( Step[Duration] ) ) VAR PeriodSum = SELECTCOLUMNS ( ReportDuration, "StartNoOfDays", ReportDuration[StartNoOfDays], "EndNoOfDays", ReportDuration[EndNoOfDays], "ReportingPeriodDisplayName", ReportDuration[DisplayPeriodName], "SortPeriodBy", ReportDuration[SortBy] ) VAR results = FILTER ( CROSSJOIN ( TaskSum, PeriodSum ), [TotalDuration] >= [StartNoOfDays] && [TotalDuration] <= IF ( ISBLANK ( [EndNoOfDays] ), 99999.99, [EndNoOfDays] ) ) RETURN results
for the following model:
And I have the following slicers:
The problem is the TotalDuration and the Band Display Name do not update when a slicer (below task) is selected.
Any help/pointers would be much appreciated.
Thanks for your help.
Andy
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |