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.
@Anonymous - You need to use a variable, like this:
inserted = var selected_fiscal_week = MAX('CALENDAR'[Fiscal Week]) return CALCULATE ( [Sum of Opps (All opps)], FILTER ( ( 'CALENDAR' ), 'CALENDAR'[Fiscal Week] > 0 && 'CALENDAR'[Fiscal Week] <= selected_fiscal_week ), 'CALENDAR'[Fiscal Year]=2019 )
@Anonymous this does not filter my chart, it still shows up through the current fiscal week (35) and does not change the line when the parameter value is changed.
@Anonymous - What do you mean by a parameter value? Could you share a screenshot?
Thanks,
Nathan
@Anonymousso there's a "What if" parameter on the page with a series generated from 1-53,
@Anonymous - The measure will need to refer to the "what if parameter":
inserted = var selected_fiscal_week = MAX('Your What If Parameter Table'[Your What If Parameter Column]) return CALCULATE ( [Sum of Opps (All opps)], FILTER ( 'CALENDAR', 'CALENDAR'[Fiscal Week] > 0 && 'CALENDAR'[Fiscal Week] <= selected_fiscal_week ), 'CALENDAR'[Fiscal Year]=2019 )
@Anonymous I have done that and it continues to show to the current week, even when I change the parameter
@Anonymous - Could you share your pbix and expected result? Or screenshot of all pertinent info and expected result?
Thanks,
Nathan
@Anonymous
My line chart is created using these measures:
@Anonymous - I'm not sure what else to try, except some troubleshooting steps. Your original measure works with a hard-coded max week. The measure with a variable based on MAX(Parameter[Fiscal Week]) is not working, so then I'd test the value for MAX(Parameter[Fiscal Week]) in a separate measure. If that is giving the proper value, then the only way for the measure with variable to be wrong is for relationships to be messing it up somehow. But, to troubleshoot, I'd need the pbix.
Thanks,
Nathan
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 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |