Forum Discussion
Gauge Visual
- 8 months ago
christinas , I think you should consider the bullet chart for this
https://marketplace.microsoft.com/en-ph/product/power-bi-visuals/WA104380755?tab=Overview
- Anonymous8 months ago
Hi christinas ,
Try below measure.
Individual Score =
AVERAGEX (
'Survey',
('Survey'[Q1. I feel my work is meaningful and contributes to the company's success] +
'Survey'[Q2. I am able to balance my work and life] +
'Survey'[Q3. I am satisfied with my current job])
/ 3
)
In the Gauge Visual,
Value → Individual Score
Minimum → 1
Maximum → 6
Target value → your benchmark (e.g., 4.5)
If you want to show Each Question as Bars
Create three measures:
Q1 Score = AVERAGE('Survey'[Q1. I feel my work is meaningful and contributes to the company's success])
Q2 Score = AVERAGE('Survey'[Q2. I am able to balance my work and life])
Q3 Score = AVERAGE('Survey'[Q3. I am satisfied with my current job])
Use a clustered bar chart with these measures.
If my response as resolved your issue please mark it as solution and give kudos.
Hi christinas,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Ashish_Mathur, Anonymous, alish_b, amitchandak, for those inputs on this thread.
Has your issue been resolved? If the response provided by the community member Ashish_Mathur, Anonymous, alish_b, amitchandak, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.