Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet 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!
| User | Count |
|---|---|
| 97 | |
| 70 | |
| 50 | |
| 42 | |
| 40 |