Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Formatting numbers in Matrix visual

Hi all,


I am using a Matrix visual and some of the values in one column are in the millions while other numbers in the same column are in the thousands. How can I format the column to show 1M for 1 million while other values show 2k for 2 thousand?


thank you!

Solution Sage
Solution Sage

Solution Sage
Solution Sage



You can try calculation group, see below blog:


Hope this helps.

Super User
Super User

@Vind1989 , you may have to write measure using format function and value range


Can you share sample data and sample output in table format?

@amitchandak  I will share a sample in a bit. I have seen someone use a table that was placed in the "Columns" section of the visual that did all the formatting, I have no idea how that was done though

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors