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

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago

Hi jthomson

 

Thanks for your reply, I did try the numeric slicer, it works great in preview, however when I publish the report it converts the numeric slicer to a list

 

As this option doesn't work on a published report, is there a workaround?

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