Matrix visualization format

DAX DAX Calculations
1

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

2

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

1 Like
3

@datadragon,

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ā€¦

image
image1001Ɨ544 66.3 KB

Hope this is helpful.

  • Brian
2 Likes
4

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ā€™
image

1 Like
5

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
6

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
7

Thank you @BrianJ I appreciate your help

8

Thank you for your suggestion @AntrikshSharma

9

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