Gauge Visual

[christinas]

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

[amitchandak · Accepted solution]

@christinas , I think you should consider the bullet chart for this 

https://marketplace.microsoft.com/en-ph/product/power-bi-visuals/WA104380755?tab=Overview

[christinas]

Hi. Thank you all for the suggestions. I will try them all. 

[v-kpoloju-msft]

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.

[Ashish_Mathur]

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).

[Anonymous · Accepted solution]

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. 

[christinas]

This measure worked great. Thank you.

[alish_b]

Hi @christinas ,

Can you share a basic mockup or sketch of the output you are trying to achieve?

[amitchandak · Accepted solution]

@christinas , I think you should consider the bullet chart for this 

https://marketplace.microsoft.com/en-ph/product/power-bi-visuals/WA104380755?tab=Overview