Forum Discussion

aellison's avatar
aellison
Icon for Helper I rankHelper I
9 years ago
Solved

Passing Parameters to Query Editor from another table

I have a table imported to PowerBI Desktop that will end up in the powerbi.com portal. This table has a DateKey column in it (we'll call this OrderDateKey). I am going to be joining that to a DateDim...
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    aellison One of the new feature for query parameters is to be able to use other queries as a source for it. So you can create two new queries that gives max and min values and set that as a source for your parameters and then use those parameters to filter DateDim table.

     

Jcasadoa's avatar
Jcasadoa
Regular Visitor
8 years ago

The field query is not editable for me. 

I have a query available but I can't select anything at all.

Does anyone know what can I be doing wrong?

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Jcasadoa I had this issue too, fixed it by transforming to a list

 

hope that helps :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi guys,

     

    I'm missing something out...

     

    I did what you described, but my parameter value is still keeping the "Current Value" field content instead of updating with the Query value I placed in "Query" field.

     

    It's like regardless the stuff I place in "Query" field, the parameter is stuck on the "Current Value".

     

    Could you help ?

     

    Thanks