Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 🙂

 

Thanks for your precious insights !

 

Benjamin

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

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

 

 

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.
Anonymous
Not applicable

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

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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.