Gauge chart

[valio21]

Hello community,

I have a question about Gauge chart. I have a bar chart with regions and performance for every region with %, and there are negative % too. My boss asked me if I can make a Gauge chart, which calculate only the positive % that is shown on the chart.

This is the bar chart, and the Gauge have to calculate all the green bars.

Thank you in advance!

[hackcrr · Accepted solution]

Hi, @valio21 

To create a gauge chart that calculates only the positive percentages in a bar chart in Power BI, you can first create a metric:

Create an indicator that only counts positive values from existing performance indicators

PositivePerformance = 
CALCULATE(
    SUMX(
        YourTableName, 
        IF(YourTableName[Performance] > 0, YourTableName[Performance], 0)
    )
)

Insert the gauge chart:
Click the Gauge icon in the Visualization pane.
Drag the PositivePerformance metric to the Value field.
Adjust the Minimum, Maximum, and Target values in the Gauge Settings as needed.

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly