Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Under Manage Parameter, when i use Suggested Values as Query, is there a way to set the Current Value to one of the item in the query result?
Example: if my query result is a list of dates, i would like to set the latest date as default and have my report use that when i first open the report.
Solved! Go to Solution.
As it looks, we cannot use dynamic values in parameters right now: https://community.powerbi.com/t5/Desktop/Options-to-have-report-parameters-similar-to-what-we-have-i...
So the option I see for you would be to add a column to your calendar-table where only for the current day, a fixed expression/value like "Today" will be returned. You could then "hardcode" that in your parameter.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
@Anonymous , @Mmahachi
I found a very helpful video by GuyInACube on Youtube about updating parameters via a REST call from PowerShell.
Hello, resurrecting this one - I'm trying to do the same (fill in localnow as the current value by default, but can be overridden in Service if needed). Any new features that can allow this? Thanks in advance!
This is a DAX formula that cannot reference parameters.
What exactly are you trying to accomplish?
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
did you get the solution for this - i'm trying to do the exact same thing. I put in the power query formulas for bringing back today's date but it's not extracting the date as the parameter, the parameter just shows the formula.
date.from(datetime.localnow())
As it looks, we cannot use dynamic values in parameters right now: https://community.powerbi.com/t5/Desktop/Options-to-have-report-parameters-similar-to-what-we-have-i...
So the option I see for you would be to add a column to your calendar-table where only for the current day, a fixed expression/value like "Today" will be returned. You could then "hardcode" that in your parameter.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |