Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 and 36 months
I have the age of animal age in months, my issue is that I don't know how to create a filter that will give me a list of the animals that match the filter criteria
Here is a demo of data I want to filter:
RAW TABLE DATA:
CLIENTID ANIMALID AGE(MTHS)
client 1 animal 1 12
client 1 animal 2 15
client 2 animal 3 13
client 2 animal 4 19
END USER FILTER:
Age(mths) >= 12 and Age(mths) <= 14
END RESULT:
CLIENTID ANIMALID AGE(MTHS)
client 1 animal 1 12
client 2 animal 3 13
To Surmise I need a way to filter the data based on a greater than less than and a way for the user to select these parameters from a filter on the report
Thanks for any help, it is much appreciated
Solved! Go to Solution.
@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
Can you just use a Slicer visualization for Age set to Between? It's the little drop down arrow next to the eraser on the Slicer visualization.
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,
Lydia
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |