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 ,
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.
This measure worked great. Thank you.