Power Query Parameter

Hi Anonymous ,

Based on the description, power query parameter is a value and cannot be added to the slicer. The user can go through the parameters and filter the table data.

But, you can achieve similar functionality using DAX.

Add two slicers to the report and create the measure to store the selected quarters.

Then, using the following DAX formula to filter the quarter.

Measure = 
var _quart = SELECTEDVALUE('Table'[Quarter])
RETURN
IF(_quart <= [ReferenceQuarter], "Reference", 
    IF(_quart <= [ComparisonQuarter], "Comparison")
)

You can also view the following document to learn more about Power Query Parameter.

Parameters - Power Query | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.