The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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.
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.
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.
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.
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