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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Nehawns
New Member

Auto formatting for data labels in the Power BI matrix

For a matrix, I have feature to set the values to thousands, millions, none, etc but I don't have option to set them to 'Auto'. I know this can be done using measure but I am also using data bars in the conditional formatting option. If I use Format function in measure to display them as Auto then data bars don't work as measure is converted to text. We should have Auto feature as well for values. 

1 REPLY 1
MFelix
Super User
Super User

Hi @Nehawns,

 

The matrix and table visualization are not similar to the other ones, the auto feature is based on the size of the visual same happens that the values sometimes are not presented, but on the tooltips they show with the normal value.

 

In the case of the tables and matrix since you are presenting the values on a cell that does not happen because altough you could make it based on the space available you have an option that wrap the text meaning that the value will be 12.... 

 

Taking this into account one option to overcome this text format that you refer is to use the condittional formatting using  the tabular editor for the formatting using a Calculated Group that allows to setup the format in the way you need but keeping the number has you need.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors