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 All,
As show on the screenshot below, the slicer options are List and Dropdown only - no between, greater than, etc. The column is from a calculated table in DAX using ADDCOLUMN AND SUMMARIZE functions. I tried this with similar calculated tables but the other options were available. The data type is already set to Numeric (Fixed Decimal).
Proud to be a Super User!
Solved! Go to Solution.
Hi,
I've had this problem when publishing online but not on desktop. Please ensure you have the latest version of Power BI downloaded and that you have Numeric Slicer enabled as it is a preview feature.
You can activate preview features under file > options and settings > options > preview features
Unfortunately I can't offer more help than that.
Hope this helps,
Will
Hi @danextian,
After test, it works fine in October version. As the @Anonymous said, please confirm you enabled "" as shown in the screenshot below. "I tried this with similar calculated tables but the other options were available.", other colums data type is also Numeric?
Best Regards,
Angelia
You can choose "Between" in the slicer options in the slicer object to get a "slider" filter.
I'm using the October 2020 version of PowerBI and I'm getting this same problem. I have other number fields where I can enable the slider. I can't figure out the difference.
Hi @danextian,
After test, it works fine in October version. As the @Anonymous said, please confirm you enabled "" as shown in the screenshot below. "I tried this with similar calculated tables but the other options were available.", other colums data type is also Numeric?
Best Regards,
Angelia
Hi @danextian,
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. If you haven't please feel free to ask.
Best Regards,
Angelia
Sorry for the delayed reply
@Anonymous's solution worked.
Proud to be a Super User!
Hi,
I've had this problem when publishing online but not on desktop. Please ensure you have the latest version of Power BI downloaded and that you have Numeric Slicer enabled as it is a preview feature.
You can activate preview features under file > options and settings > options > preview features
Unfortunately I can't offer more help than that.
Hope this helps,
Will
hello,
Select Chart, click on drop-down "select the type of slicer" then select "Between". Now you will be able to find "Slider" option in "Format"
I am having the same problem - numeric field and I only get the Dropdown and List options in the slicer - using desktop
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |