Forum Discussion

valio21's avatar
valio21
New Member
2 years ago
Solved

Gauge chart

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!

Gauge chart
  • hackcrr's avatar
    hackcrr
    2 years ago

    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

1 Reply

  • hackcrr's avatar
    hackcrr
    Memorable Member
    2 years ago

    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