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.

     

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
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