Forum Discussion
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!
Anonymous
You can try calculation group, see below blog:
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/
Hope this helps.
3 Replies
Anonymous , 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
Anonymous
You can try calculation group, see below blog:
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/
Hope this helps.
