Display Negative Percentages in Parentheses in Power BI

Custom Formatting Negative Percentages

To format negative percentages in parentheses, use the custom format 0%;(0%);0%. Apply this format through the Modeling tab in Power BI Desktop.

Applying the Format

Select the field you wish to format, then change its format to decimal. This will ensure negative percentages appear as (-3%) instead of -3%.

Understanding Power BI Tools

Remember, DAX is utilized for analysis, while Power Query is used for data modeling within Power BI.

Common Use Cases

• 
  Creating financial reports that highlight losses
• 
  Analyzing data trends and clearly indicating periods of decline
• 
  Improving the readability of statistical data by distinguishing negative values
• 
  Enhancing accounting spreadsheets by clarifying negative growth or returns
• 
  Streamlining budget comparisons with clear visual contrasts between gains and losses

Excel vs Sourcetable: A Comprehensive Comparison

Discover the key differences between Excel and Sourcetable. Excel, a longstanding leader in spreadsheet software, offers robust data manipulation capabilities. Sourcetable, on the other hand, specializes in aggregating data from multiple sources into a single, easy-to-query interface.

Sourcetable's AI copilot sets it apart from Excel. This innovative feature assists users in creating complex formulas and templates, streamlining the data management process. Excel users rely on manual formula creation, which can be time-intensive and prone to error.

Excel's versatility is well-known, but Sourcetable's simple chat interface for AI assistance is a game-changer for those looking to maximize productivity. Sourcetable's intuitive approach to spreadsheet management makes it a compelling alternative to traditional options like Excel.