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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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!