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!View all the Fabric Data Days sessions on demand. View schedule
Hi
Is it possible to format the slicer to display as a percentage instead of a decimal, the data is entered as a percentage, in the table, but appears as a decimal on the slicer
Solved! Go to Solution.
I can see you've set the Target % Column to % in the Query Editor but
you'll have to do the same in PBI as well as you'll notice there's no Data Type % in PBI. (unlike the Query Editor)
So go to the Modeling tab select the Target % Column and change the Format to Percentage!
(Data Type would be decimal in your case)
Hope this helps! ![]()
I can see you've set the Target % Column to % in the Query Editor but
you'll have to do the same in PBI as well as you'll notice there's no Data Type % in PBI. (unlike the Query Editor)
So go to the Modeling tab select the Target % Column and change the Format to Percentage!
(Data Type would be decimal in your case)
Hope this helps! ![]()
Sean, Still I am facing the problem after making above changes, can anyone provide proper solution as I am also facing same problem.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!