how to show K and M values in Pie Chart

[tan_thiamhuat]

How can I show those K and M values in a Pie Chart?

[v-menakakota]

Hi @tan_thiamhuat , 

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @nilendraFabric  and @burakkaragoz  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Best Regards, 
Menaka.
Community Support Team 

[nilendraFabric · Accepted solution]

Hi @tan_thiamhuat 

Click on your Pie Chart visual.
• Go to the “Format” pane (paint roller icon).
• Expand the “Data labels” section.
• Find the “Display units” dropdown.
• Select “Thousands” (or “K”).

[burakkaragoz]

Hi @tan_thiamhuat ,

If you're working with a Pie Chart visual in Power BI and want to keep the K and M suffixes (like 400.57K or 3.52M) visible in the chart labels, here's a trick that usually works well:

1. Create a new column in Power Query or DAX that formats the numbers as text with the suffixes. Something like:

   BookingLabel = 
   VAR val = [BookingCount]
   RETURN 
       SWITCH(
           TRUE(),
           val >= 1000000, FORMAT(val / 1000000, "0.00") & "M",
           val >= 1000, FORMAT(val / 1000, "0.00") & "K",
           FORMAT(val, "0")
       )

1. Then use this new column as the Legend or Details in your Pie Chart, and keep the original numeric column in the Values field.

This way, the chart still uses the actual numbers for calculation, but the labels show the formatted version.

Also, make sure Data label display units in the visual formatting pane is set to None, so it doesn’t override your custom formatting.

Let me know if you're using a specific tool like Fabric's Direct Lake or semantic model, cause the approach might slightly differ.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[tan_thiamhuat]

I have 3 types of booking, so what does your BookingCount refers to?

[v-menakakota]

Hi @tan_thiamhuat ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

If you're looking to show K/M formatted values (like 704.28K, 3.52M) directly inside a Pie Chart, Power BI doesn't allow custom-formatted values directly in the "Values" field of the pie. However, there’s a workaround that gives you both accuracy and formatting clarity.

I have shared you pbix file in which i have created two reports one is the pie chat report.

Since the Pie Chart itself limits how labels can be customized, I used a slicer to select the BookingType, and a Card visual to dynamically show the formatted FormatedBookingCount value (e.g., "704.28K"). This was done inside a dedicated tooltip page, which is then attached to the Pie Chart.In the pbix file page2 check the report.

 

So when a user hovers over a slice, they get a clear, styled card showing the formatted value, without affecting the numeric logic of the chart itself.

This approach also makes it easier to scale across visuals and avoids truncation issues in Pie Chart labels.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Best Regards, 
Menaka.
Community Support Team