Forum Discussion
Create variable to user in Metrics/Reports data
Hi Team,
I have a requirement to use a variable to filter the metrics data, or sometimes put filter at the report level too.
e.g If I have a revenue metric, I want to see the revenue untill the data fetched by the variable, And the variable gets the data from the oracle table which keeps changing.
How do I store the date in the variable so that I can use it in the metric. When I create a parameter, and select Query, the box is disabled.
Am I doing something wrong here ?
What is the other way of doing it.
Regards,
Akash
8 Replies
akj2784,
Please take a look at the following similar thread, I provide detailed steps to populate the parameter list based on a query.
http://community.powerbi.com/t5/Desktop/Query-for-parameter-suggested-values-global-variable-for-entire/m-p/77014#M32082
Regards,
LydiaThank you. I am able to create a new parameter. But how do I use it in the filter.
e.g I want to put Project Date < Parameter Value. When I put this filter, basically my revenue should show only until the cut off date of Parameter value.
And I want to apply it to all the reports and metrics. Sometimes to a specific metric in the report but not at report level.
Meaning, I can have a metric to show the data untill the Parameter Value and another metric independant of Parameter value.
Regards,
Akash
akj2784,
After you set a date value for the parameter, go to Date fields of your tables, then filter the Date fields to be "is before or equal to" parameter, there is an example for your reference.
Regards,
Lydia
