cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hhuddleston Advocate I
Advocate I

Number Formatting on Card Visualization

I have a card visualization that totals the number of ticket scans for a tourist attraction. This is a direct query dataset, so it is essentially giving real time data, updated every minute. The number in the dataset is an int data type and I have set it as a comma seperated whole number in the Modelling tab, and the format is also set as a whole number.  In the card format for Data Label Display units is set to None. The issue is that is displays properly as a comma seperated number up until it reaches 10,000, but then the display switches to 10.1 K instead of 10,100 (or 10,125) which is how I want it to display. The attraction manager wants it to show it as a comma seperated number no matter how high the number goes. Any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
hhuddleston Advocate I
Advocate I

Re: Number Formatting on Card Visualization

I managed to get this to display properly, using the following settings:

 

Data Modeling in PBI model

  • Data Type - Whole Number
  • Format - Whole Number
  • Thousands Seperator - Enabled
  • Decimal Places - 0

Visualization for Card

  • Display Units - None

Thanks for everyone's input!

 

Herb

View solution in original post

7 REPLIES 7
Interkoubess Solution Sage
Solution Sage

Re: Number Formatting on Card Visualization

Hi @hhuddleston,

 

It is weird, I tried as you explained and I have this visual.

Can you please show us a sample in order to better understand your request.

 

Thank you,

 

Data_format.PNG

Microsoft v-huizhn-msft
Microsoft

Re: Number Formatting on Card Visualization

Hi @hhuddleston,

I import data in direct query mode, and add the date into  a card, it also shows correctly, please see the following screenshot.

1.PNG

Best Regards,
Angelia

hhuddleston Advocate I
Advocate I

Re: Number Formatting on Card Visualization

The card on the left is what I want to display - no matter how high the number goes.

The card on the right is what happens when it crosses the 10,000 mark.

 

Total Scans Examples.PNG

Interkoubess Solution Sage
Solution Sage

Re: Number Formatting on Card Visualization

Hi @hhuddleston,

 

Either you give us your sample in order to test it again, but I still have the right visual ( on the left) when I tested on my computer.

Perhaps another person can elaborate the issue ( if it is )....

Thank you

hhuddleston Advocate I
Advocate I

Re: Number Formatting on Card Visualization

I managed to get this to display properly, using the following settings:

 

Data Modeling in PBI model

  • Data Type - Whole Number
  • Format - Whole Number
  • Thousands Seperator - Enabled
  • Decimal Places - 0

Visualization for Card

  • Display Units - None

Thanks for everyone's input!

 

Herb

View solution in original post

jhauff77060 Advocate I
Advocate I

Re: Number Formatting on Card Visualization

Modeling Ribbon > New Column

Count = 1

Drag the Card Visual to the Report Canvas

Drag the new Count column from the Fields area to the Card Visual

 

Modeling Ribbon 

  • Data Type - Whole Number
  • Format - Whole Number
  • Thousands Seperator - Enabled
  • Decimal Places - 0

Visualization for Card > Format Roller

  • Display Units - None
Highlighted
zoehyang
New Member

Re: Number Formatting on Card Visualization

It works. Thank you!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors