Data analysis

Hi Lubna-Gafer123 

To analyze which product segments contribute most to profit:

1. Create Measures:

Create a measure for Total Profit = SUM(Sales[Profit]).

Create a measure for Profit Margin % =

Profit Margin % = DIVIDE(SUM(Sales[Profit]), SUM(Sales[Sales]), 0)

This calculates the profit as a percentage of total sales.

2. Build Visuals:

Use a Bar Chart or Treemap to show Product Segment on the axis and Profit or Profit Margin % as the value.

This helps identify which segments contribute the most to total profit.

3. Add Conditional Formatting:

In the visual (for example, bar chart or table), apply conditional formatting to the Profit Margin % measure.

Define performance thresholds, for example:

> 20% → Green (High Performance)

10–20% → Yellow (Average Performance)

< 10% → Red (Low Performance)

4. Interpret Results:

The visual will highlight top-performing product segments in green, showing which ones contribute most to profit.

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!