Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I have the following graph, the actual closure % is = [Total Daily Closed]/[Total Records]
There's a scenario planning which is based "What if parameter"
What I'm trying to accomplish here, is that based on the day selected calculate the scenario planning only for the day selected, so the graph should show all the days of the week overlapping and the new scenario % point out based on Selection in the filter.
Thanks in advanced,
Nicolas Blanco
Unfortunately, this does not solve my issue.
I have created a new table.
New SR Daily Closure is based on the "What If Parameter"
I need a measure to calculate the Scenario Planning only based on the selected slicer below :
Closure % = DIVIDE([Total Daily Close],[Total_Records])
Scenario Planning Closure % = DIVIDE([New SR Daily Closed],[Total_Records])
So the time series will show the Scenario Planning for the days selected, but It will overlap the not selected values. For Example, If I select Monday and Tuesday, I should see the spikes for those days and the other days (Wedsnesday, Thursday, Friday.....) should be the same as Closure %.
Slicer shouldn't filter the selected values. Show only be for the calculation.