Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
AnjanaTh
Frequent Visitor

Percentage column in slicer taking decimal input.

Hi, 

 

When I am using percentage column in slicer it is taking decimal as input for example for 20% I need to enter as .2 

Please provide me solution so that I can provide percentage value directly in slicer instead of decimal value.I can't use a custom column in slicer which is percentage column*100 in slicer as with this my percentage(%) symbol will be lost .I want the percentage symbol to be seen in the slicer .Refere below image.

AnjanaTh_0-1723627292171.png

 

2 ACCEPTED SOLUTIONS
BIswajit_Das
Super User
Super User

Hello @AnjanaTh 
You just need to change the decimal places
as.png

View solution in original post

The column you are using in the slicers

View solution in original post

3 REPLIES 3
AnjanaTh
Frequent Visitor

Which column need to change?

The column you are using in the slicers

BIswajit_Das
Super User
Super User

Hello @AnjanaTh 
You just need to change the decimal places
as.png

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors