Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Use MEASURE IN Advance Query Editor.

Can I use the Selected value from the Slicer in the Advanced Editor/Power Query Editor?

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    v-danhe-msft : For closing this ticket, I will mark this as solution, but as of now this feature is not yet available in Power BI.

     

    Thanks

    -J

4 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    Hi Anonymous,

    Based on my research, we can't use the selected value from slicer in Query Editor. I suggest you can use parameter and refer to below steps.

    1.I have entered some sample data like the picture below.

    2.Right click the column you want to select and click the “Add as New Query” function.

    3.Creta a new parameter like the below picture.

    Now you can select the filtered value.

    You can also download the PBIX file to have a view.

    https://www.dropbox.com/s/8mmh4nbtc69px2e/Use%20MEASURE%20IN%20Advance%20Query%20Editor.pbix?dl=0

     

    Regards,

    Daniel He

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    Hi Anonymous,

    could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, v-danhe-msft, I knew about the parameter, but i wanted to try this with measure.

      • Anonymous's avatar
        Anonymous
        Not applicable

        v-danhe-msft : For closing this ticket, I will mark this as solution, but as of now this feature is not yet available in Power BI.

         

        Thanks

        -J