Forum Discussion
need help with slicer
I am using bind parameters option to dynamically fetch the data by modifying the sql query in advanced editor. Till then it works. Now, the client wants to copy paste list of values in slicer, someth...
speedramps
Super User
Super UserSo you want you user to copy and paste a list 50 values and then use that list to filter you report?
Consider building a new 'config' table with a one to many relationship to your fact table.
Then use Share Point, Power Automate flow or Power App to update the 'config' table.
The user can then update the table to filter the reports
In my case, I am using a single table, and as a slicer value, i am using distinct value from that table. however, i will look if i can somehow use Share Point, Power Automate flow or Power App to update