Percent of total formatting

  • A Show Values As option is available for measures added to table and matrix visuals to display the measure value as a percentage of the row, column, or grand total. However, measures in table and matrix visuals cannot currently be formatted to display units and decimal places such as thousands or millions.
Show Value as Option for Table and Matrix Visuals
  • For table visuals, only Percent of grand total is available given the single dimension of the visual.

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.