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/
@MikeKK , 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.
Proud to be a Super User!
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 us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
User | Count |
---|---|
442 | |
146 | |
122 | |
52 | |
51 |
User | Count |
---|---|
447 | |
131 | |
119 | |
79 | |
70 |