Forum Discussion
matrix cell format in millions
I can't find where I can format the matrix cells to 19.8M instead of 19840876
Any suggestions?
Hi Satch,
Unfortunately, the matrix visual doesn't provide OOTB feature for us to set unit for displayed values. One workaround may be create a measure like this Measure 2(M) = MAX('Table3'[Column2])/1000000.
You can also vote on this similar idea: New Matrix Visual.
Best Regards,
Qiuyun Yu
4 Replies
Satch This is an old thread but thought I'd respond because it was the first match. There is OOTB features that now alllow you to format the matrix cells to 19.8M instead of 19840876. To do this, click the visual, then under the Visual tab, scroll down to Specific column, expand Values, then select your display units. See image below.
Hi Satch,
Unfortunately, the matrix visual doesn't provide OOTB feature for us to set unit for displayed values. One workaround may be create a measure like this Measure 2(M) = MAX('Table3'[Column2])/1000000.
You can also vote on this similar idea: New Matrix Visual.
Best Regards,
Qiuyun YuThnks, hat was my initial thought to cerate a measure.
Now I'm sure thats the only way.
Solved!
I didn't see anything like in the Card visualization.
