Hide displayed unit in matrix visual

[Anonymous]

Hi all,

I present some data in a matrix visual. Within this visual, units are displayed in K€.

I am trying to hide the K€ units while maintaining my value in K€. It would clarify the table which is already a bit heavy with multiple columns...

Is it possible in Power BI ?

Of course there is a workaround, which is divinding my figures by 1000 but it does not seem to be a best practice 🙂

Thanks for your precious insights !

Benjamin

[v-lili6-msft]

hi, @Anonymous 

See Display units and precision control for table & matrix columns in Power BI Desktop

Or you could use FORMAT Function to custom the format of it.

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft ,

Thanks for replying.

This option does not seem to be available in Power BI according to your link and some further documentation I read. 

I assume that using the FORMAT function requires to custom any values displayed on the matrix table...

Best regards,

Benjamin

[v-lili6-msft]

hi, @Anonymous 

Update your power bi desktop to the latest version.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13760049-customize-values-in-matrices-and-tables

Use Format function to custom any values is also a great way.

Best Regards,

Lin