Data analysis

For analyzing which product segments contribute the most to profit, the key is to start with solid measures and then build visuals that highlight performance differences.

1) Calculate Profit and Margin %
First, create the basic measures in your model:

• Profit = Sales – Cost

• Profit Margin % = DIVIDE(Profit, Sales)

These two will let you see not just total dollars but how efficiently each segment is earning.

2) Segment Breakdown
Put your product segments (e.g., product category, brand, or SKU grouping) on rows in a table or matrix visual, and add your Profit and Profit Margin % measures. This makes it easy to see which segments are the main profit drivers.

For example, if you were analyzing something like the product categories on ATLRx’s site — they’ve got oils, and distillates — you’d use those segments and look at their margin % and total profit to see which areas are actually moving the needle.

3) Conditional Formatting in visuals
Once you have the measures, conditional formatting is where the visual insight kicks in:

• Set up thresholds like
  – Green for margin % ≥ 20%
  – Yellow for margin % between 10%–20%
  – Red for <10%

In Power BI, you can apply this in a table/matrix by going to the measure > Conditional formatting > Font/background color based on rules. That way you instantly see top and weak performers at a glance.

4) Visuals That Help
Besides tables, bar charts with color rules or heatmaps can show segment performance trends. If you have a lot of segments, slicers or small multiples can help break it down by year/quarter.

The main idea is to let the numbers speak — profit volume tells you scale, while margin % tells you efficiency. Use both together + color cues to answer your original question of “which segments contribute most to profit”.

Let me know if you want examples of DAX measures or screenshot tips!