Forum Discussion
Anonymous
8 years agoNot applicable
Use MEASURE IN Advance Query Editor.
Can I use the Selected value from the Slicer in the Advanced Editor/Power Query Editor?
- Anonymous8 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
v-danhe-msft
8 years agoMicrosoft 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