Help Needed with Field Parameters for Gauge Chart

[i96_md]

Hello Power BI Community,

I am trying to use Field Parameters to dynamically change the values presented in a Gauge Chart. Specifically, I want the chart to update so that if the user selects "Engineering," both the target value and the actual value displayed relate to engineering metrics. However, I haven't been able to get it working as expected. Has anyone successfully implemented this? Or is there a more straightforward approach than using Field Parameters?

Thank you!

[Thejeswar]

@i96_md ,

Can you share some sample data in the same format as that you are using? 

[i96_md]

Sure 🙂

[Thejeswar]

@i96_md ,

Kindly share in a format that we can copy and use. Images won't help.

Also when I expand that image all I see is a black screen.

[i96_md]

Appologies for the trouble! 

Month	Project	Overall Planned Progress % (Cumulative)	Overall Actual Progress % (Cumulative)	Engineering Plan % (Cumulative)	Engineering Actual % (Cumulative)	Procurement Plan % (Cumulative)	Procurement Actual % (Cumulative)	Construction Plan % (Cumulative)	Construction Actual % (Cumulative):
June	X	100%	92.85%	100.%	99.73%	100%	100%	100%	97.52%
June	Y	92.07%	57.21%	100%	99.83%	100%	95.50%	94.14%	27.44%
June	Z	90%	77.52%	100%	98.75%	100%	93.27%	100%	77.54%

[Thejeswar · Accepted solution]

@i96_md , This Dataset that you are using may not be the best suitable format for use with Field Parameters. 

In general implementation of field parameters, the measure itself is used as the field. So when the field parameter is selected, the measure is selected. For example, in your case, when you select Engineering both Actual and Plan values need to change. I am not sure if this can be done in a straight forward manner.

Instead of using field parameters, I would go with implementation using Bookmarks where I will have separate visuals for each of the category and render them based on selection. 

Learn about Bookmarks here

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

You can refer this video for this

https://www.youtube.com/watch?v=3wVKm1JGuHc

[i96_md]

It worked beatifully! 

Can't believe that I missed to think about 'Bookmarks' to trackle this issue. 

Many thanks! 🙂