Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have a Fiscal Year in my time table.
Works great, except when I use a filter and set it to show a slider it slides through decimals so Fiscal Year can be 2014.262981... which...is just crazy.
Why is there not a way to make the slider stick to integers/whole numbers if the source is integer?
My years are integers not decimals....???
I'm not able to replicate this behavior, what versin of Desktop are you on. I couldn't replicate this at all whether my Year column was set to Whole Number or Decimal Number. Slicers should only show the values that exist in the column. I am assuming we are talking about slicers here and not filters as I am not aware of a way to have a filter show a slider.
User | Count |
---|---|
98 | |
76 | |
76 | |
49 | |
27 |