Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
8 | |
3 | |
3 | |
2 | |
2 |