Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can I use the Selected value from the Slicer in the Advanced Editor/Power Query Editor?
Solved! Go to Solution.
@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
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
Thanks, @v-danhe-msft, I knew about the parameter, but i wanted to try this with measure.
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |