Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I have a locations with multiple sub sites connected in the scorecard, calculating employees headcount sitewise. The total headcount is rounding up to 'K'. i want to see full number instead.
Example: As shown in the screenshot scorecard display value as 10K instead of 10,487.
Thank you in Advance!
Solved! Go to Solution.
I understand, but Power BI will use the numeric notation and because of that, 10,487 will show up as 10K if whole number is used. A decimal will display as 10.487K, which ppl will read as 10,487.
Proud to be a Super User! | |
Power BI automatically represents the number in numeric notation, but instead of a whole number you can select a decimal and increase the number of decimal spaces. If you change it to a decimal with 3 decimal spots it will display as 10.487K and you get the number you want 🙂
Proud to be a Super User! | |
Hi,
Since it's the headcount i want it to be a whole number.
I understand, but Power BI will use the numeric notation and because of that, 10,487 will show up as 10K if whole number is used. A decimal will display as 10.487K, which ppl will read as 10,487.
Proud to be a Super User! | |
okay, so that's the limitation. Thanks for the help! 😊
No problem!
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
31 | |
29 | |
25 | |
24 |
User | Count |
---|---|
47 | |
33 | |
19 | |
18 | |
16 |