The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. 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.