Forum Discussion
Help Needed with Field Parameters for Gauge Chart
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!
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
