Forum Discussion
Enterable Text box for slicer
Hi,
I have a report whose data source is ADX function which has 4 parameters : Min Range, Max Range, From Date , To Date. I'm using the concept of parameter binding to pass the parameters to the function while retreiving the data. The scene is something like below screenshot.
The question is instead of having a big list for the slicers : Min Range, Max Range etc etc., cant we have a enterable textbox where user can enter say 1 as min range and 10 as max range.?(and the same for date inputs as well..?). Iam aware of the What If paramters concept where we could have the enterable slicer but unfortunately the slicer columns are not created in Power BI, infact they are laoded via DirectQuery from ADX function.
Any help would be greatly appreciated.
Thanks,
Sai Priya.
2 Replies
- PC2790
Community Champion
Hello Anonymous ,
The custom visual - Text filter came to my rescue for a similar requirement.
See if works for you.
- AUDISU
Resolver III
Hi Anonymous ,
Use parameters.
Create four parameters. Then it will give you four text boxes to enter the values. You can call those values in your DAX formula.
Thank you