Forum Discussion
Gauge Visual
Hello community,
I am new to PBI and would appreciate any help. I have results for an employee engagement survey. Excel is formatted so each row is one employee and the columns are employee info as well as each question.
The first three questions are in category ‘Individual’ and the range for each question is 1=low to 6=high. I would like the gauge to show the consolidated result of the three questions between the range. The problem I am having is the gauge is just showing the average of the range, not the actual results. My hope is to have the totals for each category as gauges and below them have the question results for each category as a bar, but my main concern is the gauge. Below is a sample of the data.
I am going cross-eyed at this point so any help would be much appreciated.
Thank you.
| race | job_family_name | Q1. I feel my work is meaningful and contributes to the company's success | Q2. I am able to balance my work and life | Q3. I am satisfied with my current job |
| Asian | Administration | 5 | 3 | 1 |
| Black | Administration | 4 | 1 | 4 |
| White | Administration | 3 | 1 | 2 |
| White | Administration | 1 | 1 | 3 |
| Two or More Races | Administration | 2 | 3 | 5 |
| White | Administration | 5 | 2 | 1 |
| White | Administration | 2 | 1 | 1 |
| Black | Administration | 4 | 2 | 5 |
| White | Administration | 3 | 5 | 5 |
christinas , I think you should consider the bullet chart for this
https://marketplace.microsoft.com/en-ph/product/power-bi-visuals/WA104380755?tab=Overview
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.
7 Replies
christinas , I think you should consider the bullet chart for this
https://marketplace.microsoft.com/en-ph/product/power-bi-visuals/WA104380755?tab=Overview
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.
Hi,
Not sure of what you want but i think you should start with "Unpivoting Other Columns" in Power Query. Via a calculated column formula, insert the question type (such as Individual, Group).
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.Hi. Thank you all for the suggestions. I will try them all.
