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.
Hi All!
Is it possible to pass values from slicers into the SQL statement. I have logic in my SQL statment that I would like to keep but I need the ability to pass in filter values for the query to return the correct results. I know you can create parameters but those do not tie into slicer values. I have also tried creaiting measures and modifying the m query.
Any help or guidance is greatly appreciated.
Hi
As tested, I'm afraid it is not possible to pass values from slicers into the SQL statement.
Best Regards
Maggie
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |