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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

The percentage values in SSAS appear as numbers in Power BI

Hi,

 

I have created a column with percentage values in SSAS. However, when I use it in Power BI, the values apear as decimal numbers. 

 

How can I fix this problem? 

 

I read this article but it does not help because the file is Json.

Re: Percentage-based KPI from SSAS Tabular model - Microsoft Power BI Community 

 

Thanks,

3 REPLIES 3
ShirinArshadnia
Helper II
Helper II

hi @Anonymous 

you can convert your value to int 

this article may be helpful :

https://dax.guide/int/

or

https://learn.microsoft.com/en-us/dax/convert-function-dax

 

Anonymous
Not applicable

Hi Shirin,

 

Thanks for your reply. I want them to appear as percentage % in Power BI as well, as they apear as decimal numbers. 

 

 

Anonymous
Not applicable

Hi Shirin,

 

Thanks for your reply. I want them to appear as percentage % in Power BI as well, as they apear as decimal numbers. 

 

 

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.