Forum Discussion

Satch's avatar
Satch
Icon for Helper III rankHelper III
9 years ago
Solved

matrix cell format in millions

I can't find where I can format the matrix cells to 19.8M  instead of 19840876   Any suggestions?
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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

Satch's avatar
Satch
Icon for Helper III rankHelper III
9 years ago

Thnks, hat was my initial thought to cerate a measure.

Now I'm sure thats the only way.

Solved!