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.
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.
User | Count |
---|---|
78 | |
77 | |
37 | |
33 | |
31 |
User | Count |
---|---|
93 | |
81 | |
59 | |
49 | |
48 |