如何在Spotfire条形图中同时显示数值与百分比？

Absolutely, this is totally doable—and it's a great way to make your bar charts way more informative for stakeholders. Here's a straightforward, step-by-step breakdown:

• Set up your base bar chart
  First, build your core bar chart by dragging your category field (like Product Category) to the X-axis and your numeric measure (like Total Sales) to the Y-axis. Get the basic visualization looking how you want before diving into labels.

• Enable data labels
  Right-click any bar in the chart and select Show Data Labels, or head to the top Visualization tab and click the Data Labels button. This will open the configuration panel for your labels.

• Build your combined label expression
  This is the key part. In the Data Labels panel, find the Label field and click the pencil icon to open the expression editor. You’ll concatenate your raw value and calculated percentage here.

  For example, if your measure is [Total Sales] and you’re grouping by [Product Category], use an expression like this:

  [Total Sales] + "\n(" + FormatNumber(Percentage([Total Sales], [Product Category]), "0.0%") + ")"
  

  Let’s break this down:

  • [Total Sales] pulls in the raw numeric value
  • \n adds a line break so value and percentage are stacked neatly
  • Percentage([Total Sales], [Product Category]) calculates each category’s share of total sales
  • FormatNumber(..., "0.0%") ensures the percentage is formatted cleanly (here, one decimal place)

  If you prefer them side-by-side instead of stacked, just remove the \n and adjust spacing:

  [Total Sales] + " (" + FormatNumber(Percentage([Total Sales], [Product Category]), "0%") + ")"
  

• Tweak label appearance (optional)
  Use the Data Labels panel to adjust font size, color, or label position (like inside the bar top, outside the bar) to keep the chart readable without clutter.

• Check your output
  Hit OK, and your bar chart will now display both the exact numeric value and its corresponding percentage for every bar.

Pro tip: If you need percentages calculated against a different grouping (like by Region instead of Product Category), just swap out the second parameter in the Percentage() function to match your desired group field.

内容的提问来源于stack exchange，提问作者BULB