Forum Discussion
Solved
Dynamic Parameter not working using M query and slicer
Hi, I have watched several videos on creating a dynamic M query using Direct Query and a parameter and then updating the parameter through a slicer in the front end. Although I followed all s...
***Solved***
I updated my PBID to the latest version and it's working now!
I think the older version let you create the dynamic M query using Oracle DB but did not work but the latest one does.
thanks for all your help!
yes amitchandak I am using the below condition :
TO_DATE('" & DateTime.ToText(DataDate) & "','YYYY-MM-DD HH:MI:SS AM')
I am not sure if there is anything wrong with this condition since it is picking the value from the parameter but not updating it from the slicer.
For eg. my default paramater value is "2022-10-18 12:00:00 AM" and below are the values I have added in my slicer :