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.
Using a what if parameter to see the effect additional budget would have on a project.
BUDGET+Additonal = 'WhatIf BUDGET'[WhatIf BUDGET Value]+sum('sage_project'[TOTAL_BUDGET])
Also have a Line/Stacked Column chart which displays month by month costs as bars and cumulative costs and budget as lines
Cumulative measure for BUDGET+Additonal is:
BUDGET+Additonal total for Date =
CALCULATE([BUDGET+Additonal], FILTER(ALLSELECTED('DateTable'[Date]),ISONORAFTER('DateTable'[Date], MAX('DateTable'[Date]), DESC)))
My issue is this measure ignores the date filter on the page and displays a line across 10 years rather than relevant years.
How can I adjust the measure to ignore the Whatif BUDGET Value oustside the filtered dates?
First pic below is the problem, last is how it should look normally
Could you not add a visual level filter for the last twelve months?
Already using a Timeline date filter visual (as some projects 3 years, some 6 months etc) on the report, only 'WhatIf BUDGET'[WhatIf BUDGET Value] ignores this filter unlike the other values.
Perhaps because the Whatif BUDGET has no relationship to the date table?
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |