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.
