Casey on 07 May 2016 02:09:21
I'd like to be able to define the detail level (hundreds, thousands, millions, etc) and the number of decimal places, (0.##, 0.###, etc) for the values displayed in matrix and table views.
Administrator on 09 Jun 2018 04:57:15
This has actually been available for a little while! In the format pane for table/matrix, look under Field Formatting, and you'll see options to customize the display units and decimal places for just that visual. Hope that helps! thanks!
- Comments (11)
RE: Customize values in matrices and tables
Is it possible to have an option to not showing display units text in the matrix?
RE: Customize values in matrices and tables
Thank you - I had forgotten this feature was there too, thanks for reminding us :)
RE: Customize values in matrices and tables
Brutal.. Just realized this functionality isn't available. Generally the automatic formatting/rounding works great - but in tables we totally lose any ability to customize the rounding. Changing the field itself works, but causes problems for other visuals
RE: Customize values in matrices and tables
Is there any alternate for this. I tried using Format but this function convert number in text that's why it is not working under value. Please help.
RE: Customize values in matrices and tables
Any number that gets displayed on a visual should be customisable like this. You're not going to draw people away from Excel and Tableau if you don't have some of the basic customisation like this.
RE: Customize values in matrices and tables
Maybe there should be a system wide default setting for rolling up values / format settings which would apply to all visuals.
RE: Customize values in matrices and tables
This is killing me. Fix this!!!
RE: Customize values in matrices and tables
It would be great to have this added alongside the new conditional formatting functionality for specific columns in matrices. Also it would be an excellent way to cleanup large matrices to more naturally tie visually to other graphics that allow the formatting of numbers.
RE: Customize values in matrices and tables
Can't believe this isn't available or that a custom visual hasn't filled the gap!
RE: Customize values in matrices and tables
This may be a duplicate idea. Is there a way to merge them and consolidate the votes?
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13760049-customize-values-in-matrices-and-tables