Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
zenone4392
New Member

Power Query Parameter

Hello Everyone, 

I have a table in power query which came from two files from different quarter, this table will be split in two table to make a comparison and extract a delta of difference between two files after a full outer join.
I've created two parameters Reference_Quarter and Comparison_Quarter, this two parameters are used inside the two tables I've mention before. 
Is it possible to set these Parameters directly from Power Bi report as a slicer?

Let's say, I have all quarters in both parameters, and from slicers I will select the Reference one and the Comparison one.

 

Thanks in advance 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @zenone4392 ,

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.

vjiewumsft_0-1731566799635.png

vjiewumsft_1-1731566812569.png

But, you can achieve similar functionality using DAX.

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

vjiewumsft_2-1731566819008.png

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")
)

vjiewumsft_3-1731566828741.png

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @zenone4392 ,

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.

vjiewumsft_0-1731566799635.png

vjiewumsft_1-1731566812569.png

But, you can achieve similar functionality using DAX.

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

vjiewumsft_2-1731566819008.png

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")
)

vjiewumsft_3-1731566828741.png

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.

marcelsmaglhaes
Super User
Super User

Hey @zenone4392 

I think is not posible set PQ parameters directly from slicer in a report. However, you can achieve a similar result by using dax and slicers to perform comparisons dynamically within the Power BI report itself.


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.