Forum Discussion
Paginated Report: Comparing Period A vs Period B Single Table Like Disconnected Slicer in Power BI
Hi smit16299
I have used disconnected parameters and have used same queries. Could you try to use nothing instead. See if this works
=Sum(
IIF(
Fields!Period.Value = Parameters!PeriodA.Value,
Fields!Amount_Custom_IS.Value,
Nothing
)
)
=Sum(
IIf(
Fields!Period.Value = Parameters!PeriodB.Value,
Fields!Amount_Custom_IS.Value,
Nothing
)
)
=Sum(
IIf(
Fields!Period.Value = Parameters!PeriodA.Value,
Fields!Amount_Custom_IS.Value,
Nothing
)
)
-
Sum(
IIf(
Fields!Period.Value = Parameters!PeriodB.Value,
Fields!Amount_Custom_IS.Value,
Nothing
)
)
- Don’t filter the dataset with parameters.
- Use expressions inside the table to show values for each period:
=Sum(IIF(Fields!Period.Value = Parameters!PeriodA.Value, Fields!Amount_Custom_IS.Value, Nothing))
=Sum(IIF(Fields!Period.Value = Parameters!PeriodB.Value, Fields!Amount_Custom_IS.Value, Nothing))
- For difference:
=Sum(IIF(Fields!Period.Value = Parameters!PeriodB.Value, Fields!Amount_Custom_IS.Value, Nothing))
-
Sum(IIF(Fields!Period.Value = Parameters!PeriodA.Value, Fields!Amount_Custom_IS.Value, Nothing))
This mimics disconnected slicers—clean, scoped, and works even with overlapping periods.
Community SupportHi smit16299 ,
Thank you Shahid12523 , MohamedFowzan1 for providing your inputs.
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.