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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PTSS
Frequent Visitor

How to Apply 2 format in 1 table field

I have sample data with Amount Decimal in Visual Matrix Power BI like this :

Account Nobuk Date Amount
1230 ER2318 8/8/2022 2200
1231 CA8754 3/4/2023 70
1232 TR3241 2/25/2023 100


How to make Amount can be used in 2 formats between decimal and percentage in Power BI like this?

Account Nobuk Date Amount
1230 ER2318 8/8/2022 2200
1231 CA8754 3/4/2023 70%
1232 TR3241 2/25/2023 100


I have tried the formula but it doesn't work :

IF([Account]<>1231,[Amount],Format([Amount],"Percent")

 

Please help us how to apply 2 formats of Decimal and Percent in 1 table field

1 REPLY 1
lbendlin
Super User
Super User

What makes you decide to treat the second value as a percentage?  It would display as 7000% anyway so you would need to change it to 0.7

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.