Matrix visualization format

I would like to keep the Millions format and remove the letter M in the Matrix visualization.

Maybe try something like this:
Measure 2 =
IF ( [Total Sales] > 0, FORMAT ( [Total Sales] / 1000000, “#,###0.00” ) )

1 Like


To my knowledge, there’s no way to do this through the matrix format options. What I do is just create a branched measure dividing the base measure by 1,000,000.

Total Sales Millions = 
    [Total Sales],

Not particularly elegant, but it works…

Hope this is helpful.

  • Brian

if you mean that you want this format: image
but just remove the “M” from the file, then you need to create a measure just for the Matrix Table like:

Total 2 = DIVIDE( [total], 1000000)
and then you will get a table like this: image
but I suggest making a note somewhere to make sure your users understand what the numbers represent.

If you mean that you want this format: image
then change the format for the value to ‘none’

1 Like

Hi @datadragon, did the response provided by the contributors help you solve your query? If not, how far did you get, and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

1 Like

To the contributor of this post. Thank you for sharing your experiences around Power BI, please don’t hesitate to add more discussion or add value to wherever you think you possess the experience or knowledge that can help others in our Ecosystem Groups. You can also help us in improving the Support forum further by answering the Enterprise DNA Forum User Experience Survey. We appreciate the initiative and your help in this group!

1 Like

Thank you @BrianJ I appreciate your help

Thank you for your suggestion @AntrikshSharma

Thank you @Heather great suggestion and they only know M and B