Forum Discussion
Help Needed with Field Parameters for Gauge Chart
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
Sure 🙂
Super Useri96_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.
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
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
It worked beatifully!
Can't believe that I missed to think about 'Bookmarks' to trackle this issue.
Many thanks! 🙂