Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.