Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
PowerAppsUser
Frequent Visitor

Changing 'bn' to 'Billion'

‎03-23-2022 09:28 AM

Hi,

 

I am trying to add the total of a column named 'Total Investment' in the Card Visual, which is coming to 2053.410 Billion. This value is being added to the Card Visual, but the only problem I have is, the format of the Callout value is showing '2053.410bn', but I want it to show '2053.410 Billion'. So basically I want to replace the inbuilt format 'bn' to 'Billion'. Any help will be appreciated.

 

Thanks!

Labels:
Message 1 of 3
1,834 Views
0
1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

‎03-24-2022 07:57 AM

@PowerAppsUser Use the Format DAX like below:

Measure_= FORMAT(SUM(Total Investment),"$#,,,.##Billion")

Capture.JPG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

Message 2 of 3
1,783 Views
2 REPLIES 2
Tahreem24
Super User
Super User

‎03-24-2022 07:57 AM

@PowerAppsUser Use the Format DAX like below:

Measure_= FORMAT(SUM(Total Investment),"$#,,,.##Billion")

Capture.JPG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Message 2 of 3
1,784 Views
PowerAppsUser
Frequent Visitor
In response to Tahreem24

‎03-24-2022 03:36 PM

Thank you, Tahreem! It worked perfectly!

Message 3 of 3
1,769 Views

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All