Comparison Chart

Yes, this is a good use case for Power BI. Based on your requirement, you want to:

• Filter by Characteristic_Name_And_ID.

• Filter by Language (so you only compare one language at a time).

• Compare the measurement value (mw_messwert) across different Plants.

• Easily identify which plant has the highest and lowest measurement values.

Recommended approach

1. Add slicers

Create two slicers:

• Characteristic_Name_And_ID

• Language

This will filter all visuals to the selected characteristic and language.

2. Create a measure for the measurement value

If each plant has multiple measurements, decide whether you want to compare the Average, Maximum, or Latest value.

For example, using the average:

Average Measurement =
AVERAGE('YourTable'[mw_messwert])

3. Create a Clustered Column Chart

Configure the visual as:

• X-axis: Plant

• Y-axis: Average Measurement

After selecting a characteristic, you'll immediately see which plant has the higher or lower value.

4. Highlight the highest and lowest plants

You can use conditional formatting with a color measure:

Plant Color =
VAR MaxValue =
    MAXX(ALLSELECTED('YourTable'[plant]), [Average Measurement])
VAR MinValue =
    MINX(ALLSELECTED('YourTable'[plant]), [Average Measurement])

RETURN
SWITCH(
    TRUE(),
    [Average Measurement] = MaxValue, "#00B050",   -- Green (Highest)
    [Average Measurement] = MinValue, "#FF0000",   -- Red (Lowest)
    "#5B9BD5"                                      -- Blue (Others)
)

Then apply this measure using Data colors → Conditional formatting (fx).

5. Add a Matrix for detailed comparison

A matrix can provide more context:

• Rows: Plant

• Columns: Characteristic_Name_And_ID (optional)

• Values:

  • Average Measurement

  • Min Measurement

  • Max Measurement

  • Standard Deviation (optional)

6. If you want to compare the latest measurement only

Instead of averaging all values, create a measure that returns the most recent measurement based on your date/time columns. This ensures you're comparing the latest inspection result for each plant.

Suggested report layout

+------------------------------------------------+
| Characteristic Slicer | Language Slicer         |
+------------------------------------------------+
| Clustered Column Chart (Plant vs Measurement)   |
+------------------------------------------------+
| KPI: Highest Plant | KPI: Lowest Plant          |
+------------------------------------------------+
| Matrix with detailed statistics by Plant        |
+------------------------------------------------+

If you're comparing measurements against USL (Upper Specification Limit) and LSL (Lower Specification Limit), you could also consider a Scatter Chart or Control/SPC Chart to visualize how each plant performs relative to the specification limits.

💡 Helpful? Give a Kudos 👍 — keep the community growing.

✅ Solved your issue? Mark this as the Accepted Solution ✔️

Best regards, Prince Singh | Data Science & Microsoft Fabric Enthusiast