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...
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

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