cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Benjamin2256 Regular Visitor
Regular Visitor

Hide displayed unit in matrix visual

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 Smiley Happy

 

Thanks for your precious insights !

 

Benjamin

3 REPLIES 3
Community Support Team
Community Support Team

Re: Hide displayed unit in matrix visual

hi, @Benjamin2256 

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

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Benjamin2256 Regular Visitor
Regular Visitor

Re: Hide displayed unit in matrix visual

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

Highlighted
Community Support Team
Community Support Team

Re: Hide displayed unit in matrix visual

hi, @Benjamin2256 

Update your power bi desktop to the latest version.

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

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

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.