How to show a Gauge Chart always with a fixed size?

[julsr]

Hello everyone,

I have two gauge charts with max and target values. When target>max, there's no line/value shown for the target in the Gauge Chart, so the size is bigger. What I want to do is ensure that the size is always the same for both of my gauge charts. How can I achieve that without removing my target value or incrementing my max value to be higher than the target?

[Anonymous]

Hi @julsr ,

Thanks for all the replies! Good answer!
And @julsr , Have you solved your problem? If solved please mark the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Best Regards,
Dino Tao

[Bibiano_Geraldo · Accepted solution]

Hi @julsr ,

Create a measure with the following DAX measure:

Gauge_Max = 
MAX(
    MAX(Gauge1_Max, Gauge1_Target), 
    MAX(Gauge2_Max, Gauge2_Target)
)

Now put this measures in both gauges Max

[rohit1991]

To keep gauge charts consistent in size when target > max without changing targets or max values:

1. Set a Consistent Max Value:

   • Manually set the same Max value across both gauges for uniform sizing.

2. Custom Target Labeling:

   • Use a DAX measure to display the target as a text label if it exceeds the gauge's range.

This keeps both gauges visually consistent.