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.