Forum Discussion
Input value parameter not working
Sampling occurs when too many values are in the column used in parameter. It is a known issue. Unfortunately, it hasn't been addressed yet
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=3cd3bbbc-7589-4696-b7f8-e0f1d08b3c42Alternatively, you can add a text column to the table and use that in a dropdown slicer instead. Just make sure to sort it by the original parameter column.
Thank you all for the replies, so the answer is that in 2024 this problem is still NOT been resolved.
Anyway I think that is just ridiculous that Microsoft spend time and resources developing useless features to wright orrible dax with Copilot but don't fix such essectial functionality.
The solution to creare a Text column of 10,000,000 and ask the Customer (User) to scroll a dropdown list until he arrive to the number he wants is horrendous.
I am migrating a report from Tableau to Power BI and in Tableau you can just creare a parameter where you type the number you want and the software build dynamically the parameter after. So much easier and user-consumer-friendly.
Hi AFoisAnalytics if you click on the ... on the right hand side of your slicer you can choose search on.
That way you can have them type in the search box instead.
Alternatively there are custom slicers free that will filter as soon as they search.