The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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ês