Gauge dynamic maximum value

[poc]

Hello,

I'm new to power bi pro, hope I find some help!

I have a gauge chart (budget), linked to a slicer with 2 filters ( contract 1 , contract 2 )

I want to get a gauge with dynamic maximum giving me a total of (budget 1 + budget 2) and when I filter with contract I get the correspondent budget ( if I filter with contract 1, I get a maximum = budget 1 in the gauge)..etc.

any Idea?

[johncolley]

Hi @poc ,

You can create a measure summing your budget column and then use it in the max value field.

Max gauge = sum(budget column)

If this answer solves your problem please mark it as a solution!