Formatting numbers in Matrix visual

[Anonymous]

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!

[mhossain · Accepted solution]

@Anonymous 

You can try calculation group, see below blog:

https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/

Hope this helps.

[amitchandak]

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

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

[Anonymous]

@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