The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am new to the Query Parameter. It seems the query parameter is only for use in Power Query. Is it possible to use the parameter in DAX or visual display , e.g. display the parameter selected in textbox. Use parameter selected in measure calculation?
Any answer or link to reference is appreciated.
Solved! Go to Solution.
Found the solution! seems I can use the parameter in DAX or in data model, check out here - https://workingondata.wordpress.com/2018/03/27/show-dataset-parameter-values-in-power-bi-reports/
Found the solution! seems I can use the parameter in DAX or in data model, check out here - https://workingondata.wordpress.com/2018/03/27/show-dataset-parameter-values-in-power-bi-reports/
@Anonymous , You can use what if , but that is limited to number or series. For text I doubt that. For text you can create an independent table and use the values in table in your measure/s.
The DAX side has it own parameters too, called What-If parameters. Does this meet your need?
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
78 | |
66 | |
52 | |
50 |
User | Count |
---|---|
121 | |
120 | |
78 | |
63 | |
62 |