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 =
DIVIDE(
[Total Sales],
1000000,
0
)
Not particularly elegant, but it worksā¦
Hope this is helpful.
- Brian
2 Likes
if you mean that you want this format: 
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: 
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: 
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