Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion

    Hello Anonymous ,

     

    The custom visual - Text filter came to my rescue for a similar requirement.

    See if works for you.

     

  • AUDISU's avatar
    AUDISU
    Icon for Resolver III rankResolver 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