Forum Discussion
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
4 Replies
- v-danhe-msftMicrosoft 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-msftMicrosoft 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
- AnonymousNot applicable
Thanks, v-danhe-msft, I knew about the parameter, but i wanted to try this with measure.
- AnonymousNot 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