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?
Go to Solution.
You can try calculation group, see below blog:
Hope this helps.
View solution in original post
@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
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.