Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
76 | |
72 | |
71 | |
48 | |
41 |
User | Count |
---|---|
54 | |
48 | |
33 | |
32 | |
28 |