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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.