Forum Discussion
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
Hi Kishore_2912
The requirement is not completely clear.
In general, you first need to create a measure that represents the value by which the plants should be compared. This could be an average, minimum, maximum, latest value, or another calculation depending on the business requirement. Simply summing the measurement values may not be appropriate, especially if the plants contain different numbers of measurements.
For the visual, a horizontal bar chart would probably be the clearest option:
* Plant on the Y-axis
* Measurement measure on the X-axis
You can then sort the chart by the measure to identify the plants with the highest and lowest values.
The language slicer should preferably be configured as single-select, since the different language rows appear to contain the same measurement values.
To provide a more specific solution, please clarify:
* Which calculation should be compared between plants: average, maximum, minimum, latest measurement, or something else?
* What result are you currently getting?
* Where exactly are you getting stuck?
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks. I would like to how did you create your bar chart i want the same like how you have created. When I try to create it is showing different
Could you explain in detail how you have achieved it?
Hi Kishore_2912
Your chart looks different from mine because there is a very large gap between BHP and the other plants.
BHP is an extreme outlier, so Power BI has to use one common axis scale that is large enough to display it. As a result, the values of the other plants are compressed, and their bars appear almost like thin lines.
This is not really a formatting issue. A bar chart is meant to show values proportionally, so it is not possible to make the smaller bars look much larger while keeping the same scale and still presenting the data accurately.
The best approach is to show BHP separately and exclude it from the comparison chart.
For example:
- Show BHP in the title, subtitle, or in a separate card above the chart.
- Filter BHP out of the bar chart.
- Use the chart to compare the remaining plants only.This way, the chart stays clear, proportional, and much more useful for comparison.
Another option is to use two separate visuals, but the scales should be clearly labelled.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
