Forum Discussion
Filter Table With Greater than, Less Than Formula
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
Hi Smoupre
I have tried the slicer visualisation filter however the only option available are list and dropdown. The Age(Mth) figures are formatted as a whole number
I did find this option in a number of articles, however in recent comments users have identified that this option no longer works (https://docs.microsoft.com/en-us/power-bi/desktop-slicer-numeric-range)
If the slicer needs 'fixed' by PowerBI then I am trying to find a workournd for this
Thanks for your help
It seems to be a preview option on mine, try playing with your settings to turn it on maybe?
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?
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,
LydiaThanks 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