Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
joglidden
Advocate III
Advocate III

Gauge maximum value filtered by 'Visual level filter' - how do I prevent this?

I don't want the maximum value in my gauge filtered by the Visual level filter. I can't find a way to prevent this. Even when I create a new measure, it still ends up getting filtered. The only thing I can do is set it manually, but of course this is useless long-term. It would be great if I could filter the values individually: Value, Minimum value, Maximum Value, Target value.

 

Any advice would be greatly appreciated.

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
Microsoft Employee


@joglidden wrote:

I don't want the maximum value in my gauge filtered by the Visual level filter. I can't find a way to prevent this. Even when I create a new measure, it still ends up getting filtered. The only thing I can do is set it manually, but of course this is useless long-term. It would be great if I could filter the values individually: Value, Minimum value, Maximum Value, Target value.

 

Any advice would be greatly appreciated.


@joglidden

 

Based on my test, if you'd like the maxinum value in gauage visual to ignore the visual level filter, you can try a measure like

MaxVal= CALCULATE(MAX(Table[Value]),ALL(Table))

Basically you don't have to use measures in Gauge visual, check Tutorial: Radial Gauge charts in Power BI. However measures are more flexible, such as in this case.

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft Employee


@joglidden wrote:

I don't want the maximum value in my gauge filtered by the Visual level filter. I can't find a way to prevent this. Even when I create a new measure, it still ends up getting filtered. The only thing I can do is set it manually, but of course this is useless long-term. It would be great if I could filter the values individually: Value, Minimum value, Maximum Value, Target value.

 

Any advice would be greatly appreciated.


@joglidden

 

Based on my test, if you'd like the maxinum value in gauage visual to ignore the visual level filter, you can try a measure like

MaxVal= CALCULATE(MAX(Table[Value]),ALL(Table))

Basically you don't have to use measures in Gauge visual, check Tutorial: Radial Gauge charts in Power BI. However measures are more flexible, such as in this case.

joglidden
Advocate III
Advocate III

To pre-emptively answer my own question, it appears that I need to create separate measures using DAX. Then, populate my gauge with those measures. Is this the preferred approach to gauges?

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors