Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hi,
if i have created a parameter list called 'station' in power query, can i select a value from that parameter list in a dax formula? this is because i'm also using the parameter list to filter data in power query.
currently i have to hardcode a value in the dax formula as shown below-
MainAirport = "JFK"
however, i'd like to select a value from a parameter list, if possible.
kindly advise.
warmest rgds, -nik
Solved! Go to Solution.
noted with thanks again, @VijayP .
for the moment, i'm opting the simple solution using SELECTEDVALUE function and using it with a slicer.
krgds, -nik
@hood2media you can consider, but there are few limitations.
Proud to be a Super User!
noted with thanks again, @VijayP .
for the moment, i'm opting the simple solution using SELECTEDVALUE function and using it with a slicer.
krgds, -nik
@hood2media Power Query Parameters cannot be used in DAX. Alternatively you can use Field Parameters in Power BI Desktop and use them
Proud to be a Super User!
many thanks for your feedback, @VijayP.
may i kindly ask if the following meets that functional requirement-
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters ?
krgds, -nik
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
37 | |
31 | |
26 |
User | Count |
---|---|
95 | |
50 | |
43 | |
40 | |
35 |