Forum Discussion

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago
Solved

Filter Table With Greater than, Less Than Formula

Hi I need to create a filer on a report to will allow the user to dynamically filter an animal table based on animal age in months with greater than less than. Eg show me animals aged between 1 an...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    justinMcC,

    Although there is no between option in Power BI Service, when I publish PBIX file which has between option in numeric range slicer, the slicer works as expected and I set different values in the slicer, please review my screenshot.



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

justinMcC,

Although there is no between option in Power BI Service, when I publish PBIX file which has between option in numeric range slicer, the slicer works as expected and I set different values in the slicer, please review my screenshot.



Regards,
Lydia

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago

Thanks to everyone for your replies, I can use 'between' as a workaround for now.

 

Hopefully the numerical slicer will have full functionality available from preview to published soon